Access 97 Report Problems

G

Guest

Hi everyone,

I have two tables in a database that has the same data
in it but for different years. I created a query to join
these two together so that I could look at the difference
of quantity purchased and the difference in total costs.

When I run the query, everything looks great... I see
records from 2003 summed by item number as well as 2004.
But when I create a report, the summed columns do not
display their associated values. Does anyone know how to
fix this?


Robert
 
Top