Matrix

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

Guest

Dear Mpv,
I have follwing data in tblPrices

ProductID Year Price
A123 2003 10.50
B456 2003 5.35
C789 2003 75.20
D123 2003 68.90
E456 2003 5.38
A123 2004 10.60
B456 2004 5.55
C789 2004 75.20
D123 2004 69.00
E456 2004 5.40
F789 2004 13.30
A123 2005 10.60
B456 2005 5.55
C789 2005 75.20
D123 2005 69.00
E456 2005 5.40
F789 2005 13.10
G123 2005 7.70

I need to see the data in a query as following. Some ideas?
ProductID Now LastYear -2years
A123 10.60 10.60 10.50
B456 5.55 5.55 5.35
C789 75.20 75.20 75.20
D123 69.00 69.00 68.90
E456 5.40 5.40 5.38
F789 13.10 13.30
G123 7.70

Best regards,
Arni Laugdal.
 
Hi,

Use a crosstab to get the arrangement. Use a form and label to get the
required titles.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top