Query by Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know this is basics.
I saw the article 304428 and read some of the posts at the newsgroup.

BUT I still cant have it done.

I am trying to do a simple query by form using the "between" so I can
specify start and ending value.
FORM NAME: Menu

TEXT BOX Name: Starting Date
TEXT BOX Name: Ending Date

QUERY NAME: Customer Exposures Query
Criteria: Between [Forms]![Menu]![Starting Date] And [Forms]![Menu]![Ending
Date]

The Result: After inserting the year at the form and running the macro the
result is no results.

Appreciate any help.
 
Henrique said:
I know this is basics.
I saw the article 304428 and read some of the posts at the newsgroup.

BUT I still cant have it done.

I am trying to do a simple query by form using the "between" so I can
specify start and ending value.
FORM NAME: Menu

TEXT BOX Name: Starting Date
TEXT BOX Name: Ending Date

QUERY NAME: Customer Exposures Query
Criteria: Between [Forms]![Menu]![Starting Date] And [Forms]![Menu]![Ending
Date]

The Result: After inserting the year at the form and running the macro the
result is no results.
Click to expand...

"After inserting the year..."?

If the fields you want to apply criteria to are date fields you will have to
supply "dates", not "years".
 
Hi Rick

THe field is as number.
THe year is just 2004, 2003, 2002, etc.

I wanted to type it at the form and run a query to open the query that would
be using the typed number as criteria.

Is it clear for you?

Thanks in advance for your time

Rick Brandt said:
Henrique said:
I know this is basics.
I saw the article 304428 and read some of the posts at the newsgroup.

BUT I still cant have it done.

I am trying to do a simple query by form using the "between" so I can
specify start and ending value.
FORM NAME: Menu

TEXT BOX Name: Starting Date
TEXT BOX Name: Ending Date

QUERY NAME: Customer Exposures Query
Criteria: Between [Forms]![Menu]![Starting Date] And [Forms]![Menu]![Ending
Date]

The Result: After inserting the year at the form and running the macro the
result is no results.
Click to expand...

"After inserting the year..."?

If the fields you want to apply criteria to are date fields you will have to
supply "dates", not "years".
Click to expand...
 
Henrique said:
Hi Rick

THe field is as number.
THe year is just 2004, 2003, 2002, etc.

I wanted to type it at the form and run a query to open the query that would
be using the typed number as criteria.

Is it clear for you?
Click to expand...

If that is the case then your original syntax looks correct.

Post the entire SQL of the query.
 
Back
Top