Comparison Report - figures from two years

[Guest]

Version: Access 2003

I am trying to create a report that includes the following fields:

Customer Name
Country
Product Line
Product
Quantity
Price
Fiscal Year: 2004
Fiscal Year: 2005

I am trying to compare the exact figures for the same products from 2004 and
2005 side by side. Maybe have a layout with two columns - one for the figures
of 2004 and one column for the 2005 figures. I am at a loss as to how to do
this.

Your help is greatly appreciated!

Regards,
Effie

 

[Rick B]

You don't tell us how your data is stored. Also, what do you want to pull
for FiscalYr2004 and FiscalYr2005? The total quantity sold? The extended
total price? The ending balance? The onhand balance at the beginning of
the year?

Whatever it is, how will you calculate that? If you tell us in English what
you want, we can turn it into Access-eze! Gotta give us details.

Rick B


"effieoliva (removethis) @msn.com"

 

[PC Datasheet]

Create two queries, one for 2004 and one for 2005. Create a third query that
includes query1 and query2. Change the third query to a crosstab query to
get 2004 and 2005 as separate columns.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


"effieoliva (removethis) @msn.com"