Date Parameters and Querys

[Kath via AccessMonster.com]

Hello all,
I need some help in having a query automatically pull a date apart and select
quarters based on the dates I specifiy. IE: Qtr 1 = between 02 month, 01 day,
and current year, etc....

I am not sure how to do this? If I do the trim can I specify the dates this
way? (I don't want the user to be prompted as this particular user will get
confused on when to enter the quarter data as it is based on billing dates
and not true "beginning of quarter dates" (IE: February is January's billing
date thus I need to capture data from Feb 01 and April is March's billing
date, so I need to capture it to April 30.)

Any help is appreciated.
Thanks,
Kath

 

[OfficeDev18 via AccessMonster.com]

Kath,

Look at DateAdd() and DateSer(). One of them is sure to help. In either one,
you can add a "q" (quarter) to any start date to capture a date three months
later. The only thing they won't do is to automatically label the first
quarter, second quarter, etc. If you need that you'll need to do it manually
(read: with VBA).

Sam

 

[Guest]

pull a date apart and select quarters
Use the date function Quarter --- Quarter([YourDateField]) and the Year
function to pull the data.