K
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
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