Date Query - Using "Between" and "AND"

[GAccess]

Hi all,

Side note: From Datapigs, the instructor shows that you should probably program any queries that will be using "AND" within the criteria. I wouldn't know how to code in VBA in order to use a query.

My level is beginning intermediate, so I still need a lot of things spelled out to me.

PLEASE HELP!

I have a search form. Within the search form the user can search for cars sold in a given period of time.

I have a table.. which lists the dates that each car was sold.

DateSold<--column name

The query I have created is not working properly. I keep getting the error code 3071- The expression is typed incorrectly, or it is too complex to be evaluated.


In my query I have - DateSold from a cars table. In the criteria row, I typed Between Datesold.beg AND Datesold.end. I want for the query to search within the column DateSold and return all cars sold within a specific period.

Example

DateSold
1/1/2001 A
1/2/2001 B
3/4/2001 C
3/8/2001 D
3/9/2001 E
3/10/2001 F

if i type in i want to search between 3/1/2001 to 3/12/2001------ CDEF should pull up.


Hope someone can help me!

[pbaldy]

At it simplest:

Between [Enter start date] And [Enter end date]

but most of us use forms to gather user input since you have a lot more control there.