That's already done - still no result. Japan uses the same date formatting as
the US so that's OK too. I have another query that returns all the records
before a specific date and it works great.

The query is pointing at the textboxes and the output form is pointing at
the query. This is very strange.

"Allen Browne" wrote:

There is a good chance that Access is misinterpreting the dates.

To help it get it right:
1. Format the text boxes.
Open the Licence Search menu in design view.
Right-click SearchDateFrom, and choose Properties.
On the Format tab, set the Format property to:
Short Date
Access then knows that the control is a date.
Repeat for SearchDateTo.

2. Declare your parameters in the query.
Open your query in design view.
Choose Parameters from the Query menu.
In the dialog box, enter two rows:
[Forms]![Licence Search Menu]![SearchDateFrom] Date/Time
[Forms]![Licence Search Menu]![SearchDateTo] Date/Time
In the context of the query, Access knows these values are dates.

More information:
International Date Formats in Access
at:
http://members.iinet.net.au/~allenbrowne/ser-36.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nick in Tokyo" wrote in message
...
I'm trying to return all the records between two dates that are entered in
text boxes.

here's what I have in there....

Between [Forms]![Licence Search Menu]![SearchDateFrom] And
[Forms]![Licence
Search Menu]![SearchDateTo]

The form exists and is named correctly, and the two date fields are there
as
well. However the query draws a blank. Is there something else I have to
do?