[mso] Re: Retrieving Previous 3 Month's Data in a Report - Access 2000 :VSMail mx3

I sure did.  I ended up using a DateSerial function, though.  It works
great.  

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of James LaBorde
Sent: Thursday, October 14, 2004 11:24 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Retrieving Previous 3 Month's Data in a Report -
Access 2000 :VSMail mx3


Sam,

Did you get an answer to this or are you still looking?

James

-----Original Message-----
From: Sam Maroney [mailto:smaroney@xxxxxxxxxx]
Sent: Thursday, October 07, 2004 9:31 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Retrieving Previous 3 Month's Data in a Report - Access
2000 :VSMail mx3


data, based on the current month.
Since this is October, I would like to be able to select 10/2004 from 
a dropdown and have the report return data for July, August and 
September. 

What do I do when I am dealing with 2 different years? If I pull a 
report in 2/2005, how do I get it to return November and December of 
2004, and January of 2005?

I know that I will be using a Between DateAdd expression in my query, 
but I am not sure what to do when the year changes.

Thanks in advance for your help!




*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will
also allow you to change your email settings to digest or vacation (no
mail). http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee.  Access to
this message by anyone else is unauthorized.  If you are not the
intended recipient, any disclosure, copying, or distribution of the
message, or any action or omission taken by you in reliance on it, is
prohibited and may be unlawful.  Please immediately contact the sender
if you have received this message in error. Thank you.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will
also allow you to change your email settings to digest or vacation (no
mail). http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************



*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: