Vba help to do this

[Ste4en]

Data in my table includes the folliwing information - the sales by week are cummulative ( I cant change the way that that happens)

Type, week1, week2, week3, week4
cars, 1, 3, 5,
bikes, 1, 2,
trikes, 0, 1, 2, 5,

I need to be able to get the data for any week as examples below.

Sales at week 4,
Cars, 5
Bikes, 2
Trikes, 5


Sales at week 3,
Cars, 5
Bikes, 2
Trikes, 2

etc

This is of course an example of the data structure but how can I achieve the results a query or some VBA.?

Thanks

Steve

 

[deBassMan]

Hi

sounds like you could use a crosstab query (as its called in Access)

check out the help file

good luck