query dates

[bosox0179]

Hi,

I am building reports that are based off of queries with the date limiters
of :

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

I found on the boards where if you place the following in an unbound text
box then you will see the date range on the report:

="Between " & [Enter Start Date] & " and " & [Enter End Date]

This works, but it prompts you to enter the dates for the query in twice.
How do I tell it to use the parameters from the query to fill in the dates so
that you only have to fill the dates in once?

 

[Duane Hookom]

Check your spelling.

I recommend that you abandon parameter prompts in favor of references to
controls on forms.

--
Duane Hookom
MS Access MVP

Hi,

I am building reports that are based off of queries with the date limiters
of :

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

I found on the boards where if you place the following in an unbound text
box then you will see the date range on the report:

="Between " & [Enter Start Date] & " and " & [Enter End Date]

This works, but it prompts you to enter the dates for the query in twice.
How do I tell it to use the parameters from the query to fill in the dates
so
that you only have to fill the dates in once?

 

[bosox0179]

How do I do that?

Check your spelling.

I recommend that you abandon parameter prompts in favor of references to
controls on forms.

--
Duane Hookom
MS Access MVP

Hi,

I am building reports that are based off of queries with the date limiters
of :

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

I found on the boards where if you place the following in an unbound text
box then you will see the date range on the report:

="Between " & [Enter Start Date] & " and " & [Enter End Date]

This works, but it prompts you to enter the dates for the query in twice.
How do I tell it to use the parameters from the query to fill in the dates
so
that you only have to fill the dates in once?

 

[Duane Hookom]

You create (or use) a form with a couple text boxes txtStart and txtEnd. You
can set default values, use calendar controls, check integrity,... if you
use these controls.

You criteria would then be something like:

Between Forms!frmDates!txtStart and Forms!frmDates!txtEnd


--
Duane Hookom
MS Access MVP

How do I do that?

Check your spelling.

I recommend that you abandon parameter prompts in favor of references to
controls on forms.

--
Duane Hookom
MS Access MVP

Hi,

I am building reports that are based off of queries with the date
limiters
of :

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

I found on the boards where if you place the following in an unbound
text
box then you will see the date range on the report:

="Between " & [Enter Start Date] & " and " & [Enter End Date]

This works, but it prompts you to enter the dates for the query in
twice.
How do I tell it to use the parameters from the query to fill in the
dates
so
that you only have to fill the dates in once?