G
Guest
Is it possible to generate a query that would change depending on the current
month and include the next 11 months after that???
I have a table with months (i.e. Feb-05, Mar-05 ... Mar-08). Each of these
months are manpower requirements for that month. Is it possible for me to
generate a query that is based upon the current date (month and year) and
give me the following 12 months from that point ?????
I can't seem figure it out if its possible. I know I could do this using
vba code where I fill in a table of 12 months with the correct start months.
Your help is deeply appreciated!!
Thanks,
Gary
month and include the next 11 months after that???
I have a table with months (i.e. Feb-05, Mar-05 ... Mar-08). Each of these
months are manpower requirements for that month. Is it possible for me to
generate a query that is based upon the current date (month and year) and
give me the following 12 months from that point ?????
I can't seem figure it out if its possible. I know I could do this using
vba code where I fill in a table of 12 months with the correct start months.
Your help is deeply appreciated!!
Thanks,
Gary