How to get total of product units in a query

[kpkiller85]

Hey guys, I'm trying to use the query feature to combine entries into a simple format.

For instance,

DATE........ITEM......SALES VOLUME.....TOTAL SALES
07-01-01...Cutlery..........10..............100
07-01-02...Cutlery..........20..............200
07-01-03...Cutlery..........30..............300

How would I set up the query so that I can see

ITEM..............SALES VOLUME..............TOTAL SALES
Cutlery..............60.........................60 0


Please help?

[mseo]

@kpkiller85
Welcome to BYTES

DATE........ITEM......SALES VOLUME.....TOTAL SALES
07-01-01...Cutlery..........10..............100
07-01-02...Cutlery..........20..............200
07-01-03...Cutlery..........30..............300

is that table or query

[kpkiller85]

Hi mseo.

Thanks for replying.

Would you care to clarify what "concate" means?

So right now, I have a query showing like this

DATE........ITEM......SALES VOLUME.....TOTAL SALES
07-01-01...Cutlery..........10..............100
07-01-02...Cutlery..........20..............200
07-01-03...Cutlery..........30..............300


Where would I incorporate

[Date]&"..."&[Item]&"..."&[sales Volume]&"..."&[total sales]

to group same records into one?

Sorry for this newbie question =/

[mseo]

there was a misunderstood of your question because it is incorrectly formatted
ok, first of all, you shouldn't use date as field name because it is reserved word use name like SDate but don't use reserved words
table should has Primary key, if not, you should index one field at least
your query should be like this:

SELECT ItemID,  Sum([Sales volume]), Sum([total sales])
FROM table name
WHERE ([SDate]) Between [SD] And [ED]))
GROUP BY ItemID;

in the where clause I set a parameter for you to show you how you can get the sum of sales between two dates

P.S you haven't mentioned that your table has a relationships with child table or maintable, and if so, you must use join within the query
you can also set the relationship between the tables in query design view

Hope this helps
MSEO

[kpkiller85]

Worked like a charm!! Thank you!

[mseo]

@kpkiller85
hi,
welcome to BYTES again
I happy to hear that form you
you should use code tags click # sign in the toolbar when you need to post the metadata, Code, SQL statements to help us understand your question properly

[NeoPa]

NB. GROUP BY queries can also be managed in the query editor. Click on the Sigma (looks like a large, reversed, angular 3) button and it will change it for you. You may need to select what to do with some of the fields.