MS Access Query problem

TruffleShuffle

TruffleShuffle

TruffleShuffle

Associate
Joined
18 Sep 2007
Posts
572
I have an access Query which returns results which are effectively product totals. For exmple, each product has about 4-5 different results, so like X product1 - Supply, X Product1 Supply & Fit, X Product2 Supply, X Product2 Supply & Fit, then you will have Y Product1 Supply, Y Product 1 Supply and fit, Y Product2 Supply, Y Product2 Supply & Fit etc etc.

How do make the query group all the X Products (1 through whatever, supply and supply and fit) and all the Y Products the same, so that when someone runs the query instead of giving individual totals, it gives a total for X Product, and a total for Y Product.

Still following? :)
 
In complete honesty Access is largely beyond me. My job remit is 80%Marketing and then 20% IT (becaise i know my fair share), after one of the other guys retired.

And as i solved a few other Query problems earlier in my time here, i have been dubed the 'access guy' :( I solve most problems by getting them to send me the database and then fidling with it till it works (usually involving a fair amount of googling too), but this one has me stumped.

They basically use an external program that inputs into an access database. Then one of them uses Pre-written Access Queries (written by the guy that retired) to bring up things like:

New Business Won & Lost
Quotes reaching completion

all that sort of thing, to give figures and targets to the sales team.

Anyways, she curently has a query which lists all the products indivdually and and their qunitities and she then adds all the same type of product together by hand. (if this was OCuk imagine a query which listed all the different graphics cards sold, then all the different CPUS sold etc etc. when what you really want is something that gave you the total Graphics cards, and total CPUS).

Sadly there is no sort of product type field for me to point to.
 
I've had the unfortunate luck of being the access guy too, if stelly hasn't fixed it fire the shots off in an email to hairybudda at gmail dot com and i'll take a look after work :)
 
You must log in or register to reply here.
Back
Top Bottom