adding records together

[Jim L.]

I have a table that is automatically written to when a refueling transaction
occurs. Fields include Date/Time, Product & Quantity. In a query, i have
changed the date/time format to just show the month & year, then a sum of
quantity to show how much of each product is used each month. I need to
create an annual report with just 2 fields per month. One that shows how
much diesel is used, and one that shows how much of the combination of all
other fuels is used. Since each product in the query displays as a seperate
record (line), is it possible to base another query on this one that adds the
non-diesel products together for each month, or is there a better way to go
about this on a report. This database is not as normalized as it should be
since I am just learning, but any solution would be appreciated.

 

[Arvin Meyer [MVP]]

You could write one query which used a calculated column to show diesel, and
another query to calculate everything but diesel. Then write another query
to combine the 2. In Access, queries are treated just like tables for
purposes of adding to other queries.