Calculation Queries

[Franklin Jagdeo]

I have made a table in Microsoft access2002 where I input TYPES: CATEGORIES:
DATE: QUANTITY SHIPPED:
How can I see the result in one Query of Quantity shipped in a given month
and also total shipped to date?
Thank you kindly for your help.
R.J.

 

[KARL DEWEY]

You need to use one query for total shipped to date and join it in the Query
of Quantity shipped in a given month.

 

[[MVP] S.Clark]

Create two queries then fuse them together. Maybe a union query.


--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html