Parameter Value Query

  • Thread starter Thread starter SusanM
  • Start date Start date
S

SusanM

Hello everyone,
New to Access, 3 months. have run into road block. have 3
Access Books none are clear. I have a table of employees.
I need to track their personal time on a daily basis.
Have set up a menu screen for the end user. on the menu
screen have set up command button, "daily time by
employee". When the end user click this button, 4
parameters will be asked: 1 the year 2 the month 3 the
date 4 employee id. this will pull the form I have
created with the specific employee info showing. I am
confused on how to create these queries after the command
button is clicked, I am missing a step somewhere.
Thanks for your help.
 
Hi Susan,
I hope I understand what you want. I'll give you and example
with one parameter.

The query might look like (SQL View):
PARAMETERS [enter Employee ID] Short;
SELECT AttendDate, Event, .....
FROM EmployeeTimes
WHERE EmplID = [enter Employee ID];

Type the name of that query in the 'Record Source' property
of the form that displays employee info. When your main form
(with the buttons) tries to open this "employee info" form,
the query will prompt the user for the parameter value.

hope this helps
Tom
 
Back
Top