M
Mal
Hi all.
I've got a table linked to Excel where every three consecutive columns are for a
specific calendar month, ie. F4, F5 & F6 are for July, F7 to F9 represent August
etc etc. I'm setting this up for the next f/y and thought it'd be cute to be
able to automatically pull stats out of it for both the current & last completed
month by using the system date/month to select the appropriate columns.
Something like;
SELECT F&MONTH(NOW())*3, F&MONTH(NOW())*3+1.....
Tragically, I'm as competent with Access SQL as is the average zuchini and can't
get it to work. Is it even possible? And if 'Yes', could some nice person point
me in the right direction.
cheers
Mal
I've got a table linked to Excel where every three consecutive columns are for a
specific calendar month, ie. F4, F5 & F6 are for July, F7 to F9 represent August
etc etc. I'm setting this up for the next f/y and thought it'd be cute to be
able to automatically pull stats out of it for both the current & last completed
month by using the system date/month to select the appropriate columns.
Something like;
SELECT F&MONTH(NOW())*3, F&MONTH(NOW())*3+1.....
Tragically, I'm as competent with Access SQL as is the average zuchini and can't
get it to work. Is it even possible? And if 'Yes', could some nice person point
me in the right direction.
cheers
Mal