T
Tommy2326
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?
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?