Date that falls between 2 other dates

[Txlonghorn76]

I have a query which includes an Invoice date field and I want only the
invoice dates that fall between the Start Date Field and the End Date field.
How can I tell the query to select all invoice dates that are greater than
the Sate Date field and less than the End date field?

 

[akphidelt]

In the Invoice Date criteria put in

Between [Start Date Field] And [End Date Field]

If you are manually plugging in the date values then use # signs like

Between #1/1/2008# And #12/31/2008#

 

[Ivan Grozney]

Are StartDate and EndDate values from a form or are you going to hard code
these in?

If from a form:
Between forms!_your form name here_!StartDate AND forms!_your form name
here_!EndDate

< forms_your form name here_EndDate AND > forms!_your form name
here_!StartDate

Hard Coded
Between #1/1/2003# AND #2/2/2009#

#1/1/2003# AND <#2/2/2009#

HTH

Vanya

 

[Txlonghorn76]

They Start Date and End Date are from a table that will get updated weekly.