SQL and Pop up boxes

  • Thread starter Thread starter Vern
  • Start date Start date
V

Vern

The following SQL runs from a form I call Print_Screen. I
call up a cross tab query report from the form, type in
specific dates to start and to end the report and click
the print icon on the form. When I click the icon, up pops
a box asking for the parameters again, one for start date
and then one for end date. How can I get these boxes to
stop and the SQL to use the first date inputs??? Vern


PARAMETERS [start date] DateTime, [end date] DateTime;
TRANSFORM Sum([Main Header].[Hours Worked]) AS [SumOfHours
Worked]
SELECT [Main Header].[Employee ID]
FROM [Main Header]
WHERE ((([Main Header].[Date/Time]) Between [Start date]
And [End date]))
GROUP BY [Main Header].[Employee ID]
PIVOT [Main Header].Activity_Type
WITH OWNERACCESS OPTION;
 
Every time you run your parameter query, it will prompt you for the
parameters. I would place text boxes on a form and set the criteria and
parameters to something like Forms!Print_Screen!txtStartDate.
 
Back
Top