make a query dependent on a variable on a form or report

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

I am trying to find a way to take the following query:

SELECT Timeslip.EmployeeID, Timeslip.Day, Timeslip.TaskName, Timeslip.Hours,
Timeslip.TaskType, Timeslip.Comments
FROM Timeslip
WHERE (((Timeslip.EmployeeID)="4.0363"));

and

1) make the Where statement dependent on a control on either a form or report

2) get the result into a report in the least number of clicks for the user.

Thanks.

JR
 
Thanks!

It almost works.

the variable gets passed to the report, but it never gets acted on. I went
to properties and there under filter is the value that was entered on a form.
Used the form to change the values a couple of times ... each time the value
changed. But the report does nothing with it.
Report is set up to execute the filter on opening.

Trying to make it happen!

JR
 
Back
Top