Date parameters in a query

[Guest]

I've created a query, Production Time, with a parameter set to look up values
between two dates. The query is to show Time Available, Running Time and
Downtime. The value for Time Available is taken from a table, the Running
Time and Downtime are taken from a query. The Run Time and Downtime queries
contain the parameter to select dates. When I run the Production Time query
I have to enter the start date and end date twice, how do I change this so I
only have to enter the dates once?

 

[Guest]

Copy one set of parameters into the second query so they are identical.

 

[Guest]

Create a form not linked to any table (AKA unbound form) named frmSearch. On
this form put two text boxes named txtStartDate and txtEndDate. Also put a
button on the form that will run the query. The Command Button wizard will
guide you through it under Miscellaneous, Run Query.

In the query put the following in the appropriate criteria boxes:
[Forms]![frmSearch]![txtStartDate]
[Forms]![frmSearch]![txtEndDate]

You put the dates in the form and then run the query. The form needs to stay
open; however, it could be minimized or even hidden.

 

[Guest]

Thanks, got that working now

Create a form not linked to any table (AKA unbound form) named frmSearch. On
this form put two text boxes named txtStartDate and txtEndDate. Also put a
button on the form that will run the query. The Command Button wizard will
guide you through it under Miscellaneous, Run Query.

In the query put the following in the appropriate criteria boxes:
[Forms]![frmSearch]![txtStartDate]
[Forms]![frmSearch]![txtEndDate]

You put the dates in the form and then run the query. The form needs to stay
open; however, it could be minimized or even hidden.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I've created a query, Production Time, with a parameter set to look up values
between two dates. The query is to show Time Available, Running Time and
Downtime. The value for Time Available is taken from a table, the Running
Time and Downtime are taken from a query. The Run Time and Downtime queries
contain the parameter to select dates. When I run the Production Time query
I have to enter the start date and end date twice, how do I change this so I
only have to enter the dates once?