Is their other better easy way to do this?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had develop an 2k3 Access database for management to project the sales. The
user will select any prior period information to compare with current
information.
For example:
Item Date 2005 2006 2007
200512 $1000 $1500 $1800
Apple 200601 $1020 $1700 $1850
Different $ 20 $ 200 $ 50
 
I had develop an 2k3 Access database for management to project the sales. The
user will select any prior period information to compare with current
information.
For example:
Item Date 2005 2006 2007
200512 $1000 $1500 $1800
Apple 200601 $1020 $1700 $1850
Different $ 20 $ 200 $ 50
------------------------------------------------------
200512 $ 800 $ 900 $ 950
Orange 200601 $ 825 $ 950 $ 975
Different $ 25 $ 50 $ 75
.
.
In my VBA code I create the temporary table on the fly, and then load the
data to the unbound textbox. It works fine. But it's difficult for other
people to maintain the program, if they are not familiar with SQL.
Is their other better easy way to do this?
Click to expand...

A stored Crosstab query, using Year([datefield]) as the column header
and Item as the row header, would appear to be appropriate.

John W. Vinson[MVP]
 
Back
Top