I have a query where it lists the months within a certain period of time inputted by the user. What I need to do, because of information in another table, is put a numbering system in.
Lets say the Start Date is 4/1/2003 and the End Date is 8/31/2003
The qry needs to look like this:
Month
1 April
2 May
3 June
4 July
5 August
I have the second part automatically generated, but i need the numbering system as well.
Lets say the Start Date is 4/1/2003 and the End Date is 8/31/2003
The qry needs to look like this:
Month
1 April
2 May
3 June
4 July
5 August
I have the second part automatically generated, but i need the numbering system as well.
