Problem with a date query

[Jim]

I'm having a problem with a date query..im trying to pull customer
data based on a date specified from a form to 3 months prior to the
date specified. So lets say in the form I specified 1/2/2004. I
would need all records with a date in October '03, November '03,
December '03 and January '04. Every thing ive tried hasnt worked and
im getting all types of weird recordsets..

thanks

-Jim

[Bas Cost Budde]

Jim wrote:

I'm having a problem with a date query..im trying to pull customer
data based on a date specified from a form to 3 months prior to the
date specified. So lets say in the form I specified 1/2/2004. I
would need all records with a date in October '03, November '03,
December '03 and January '04. Every thing ive tried hasnt worked and
im getting all types of weird recordsets..

thanks

-Jim

The SQL for the query should become:

select * from yourtable where yourdate between #10/1/2003# and #2/1/2004#

Date is american format, AFAIK.

The query could look into the form directly; then, its SQL will look like

select * from yourtable where yourdate between
forms!yourform!yourcontrol and dateadd("m",-3,forms!yourform!yourcontrol)
--
Bas Cost Budde
http://www.heuveltop.nl/BasCB

[fredg]

On 3 Feb 2004 08:59:52 -0800, ji********@motorola.com (Jim) wrote:

I'm having a problem with a date query..im trying to pull customer
data based on a date specified from a form to 3 months prior to the
date specified. So lets say in the form I specified 1/2/2004. I
would need all records with a date in October '03, November '03,
December '03 and January '04. Every thing ive tried hasnt worked and
im getting all types of weird recordsets..

thanks

-Jim

As query criteria in the Date Field.

Between DateDiff("m",-3,forms!NameOfForm!NameOfControl) and
forms!NameOfForm!NameOfControl
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email

[Jim]

fr***@example.invalid wrote in message news:<sb********************************@4ax.com>. ..

On 3 Feb 2004 08:59:52 -0800, ji********@motorola.com (Jim) wrote:

I'm having a problem with a date query..im trying to pull customer
data based on a date specified from a form to 3 months prior to the
date specified. So lets say in the form I specified 1/2/2004. I
would need all records with a date in October '03, November '03,
December '03 and January '04. Every thing ive tried hasnt worked and
im getting all types of weird recordsets..

thanks

-Jim

As query criteria in the Date Field.

Between DateDiff("m",-3,forms!NameOfForm!NameOfControl) and
forms!NameOfForm!NameOfControl

Ok but this query doesnt look like it will give me all the records in january..

-Jim