Thread: Query to bring records between specified dates

Hello Guys,

I was setting up a database to run the inventory. I am trying to make a query that will bring me all the transactions made between specific dates.

Query I use looks this way: most fields coming from table:Transactions

TransactionID
PartNumber
TransactionType
Quantity
UOM - Related to another table [Part]
Date
User

I don't know how to make the query search for the dates I would be inputing. Is there anyone who could help with some suggestion. I work here on Access 2000.

Thanks for reading it and giving it a go.

Simon

In the criteria section of the Date field create parameters for a start date and an end date.

Look at this for web site for the syntax

http://www.techonthenet.com/access/q...parameter1.php

Note: The term "date" is a reserved word in Access and should not be used as a field name. It may cause you problems in the future. Change it to something else, ie. TranDate

Here is a link to Reserved Words

http://support.microsoft.com/kb/209187

Alan

Thank you for your help.

The first link has redirected me to uncover a code:

>=[Start Date] And <=[End Date]

which works beautifully for me.

Thanks again
Simon

As an alternative, you could also use Between [StartDate] and [EndDate]

Alan