G
Guest
I need to be able to query for the current quarter (2/2005) the previous
quarter and the last four quarters. I have the info in the table by date of
occurrence. Is there a way I could use the current quarter to generate the
rest? for example, the 4 previous quarters are 1/2005, 4/2005, 3/2005,
2/2005. I only want to be able to key in the current quarter from a form to
run a report but I need to compile this data for the report. I'm using
datepart to do some basic stuff but this is too complex for me.
quarter and the last four quarters. I have the info in the table by date of
occurrence. Is there a way I could use the current quarter to generate the
rest? for example, the 4 previous quarters are 1/2005, 4/2005, 3/2005,
2/2005. I only want to be able to key in the current quarter from a form to
run a report but I need to compile this data for the report. I'm using
datepart to do some basic stuff but this is too complex for me.