flaviooooo
Programmer
Hi,
I have a queryproblem. I have a table containing waste-data, sorted by week. The week is in the following format:
3703 -> week 37 of year 2003
2002 -> week 20 of year 2002
...
You get the drift.
Now I have a form where a user types a weeknumber, for example 3003.
I'd have to make a query that gives met the data of the previous 10 weeks (as well as the asked week):
3003
2903
2803
...
2003
Is this possible?
Thanks
I have a queryproblem. I have a table containing waste-data, sorted by week. The week is in the following format:
3703 -> week 37 of year 2003
2002 -> week 20 of year 2002
...
You get the drift.
Now I have a form where a user types a weeknumber, for example 3003.
I'd have to make a query that gives met the data of the previous 10 weeks (as well as the asked week):
3003
2903
2803
...
2003
Is this possible?
Thanks