D
Dave Elliott
my question is, will this work? will it advance by date and employee order
number and then go back to the starting employee and number?
i.e. Bill Gates employee 1 after going thru all the employees on call!
i have a form where i need to have it automatically advance the employees by
date and number
example: i have bill gates as a employee with a employee number of 1
forest gump with a employee number of 2
etc...
in the employees table i have the following fields;
On Call text field that stores the employee name
call Yes/No field stores whether or not employee is on
call
order employee order of on call (Number) ascending
Criteria;
(Employee) SELECT [First Name] & " " & [Last Name] AS [Employee Name] FROM
Employees ORDER BY [First Name] & " " & [Last Name];
query used for form to show who is on call qryoncalllist
uses employees table
(Date criteria for employee for the week) Call:
([Forms]![frmautopayrollreport]![StartDate] And
[forms]![frmautopayrollreport]![EndDat])
number and then go back to the starting employee and number?
i.e. Bill Gates employee 1 after going thru all the employees on call!
i have a form where i need to have it automatically advance the employees by
date and number
example: i have bill gates as a employee with a employee number of 1
forest gump with a employee number of 2
etc...
in the employees table i have the following fields;
On Call text field that stores the employee name
call Yes/No field stores whether or not employee is on
call
order employee order of on call (Number) ascending
Criteria;
(Employee) SELECT [First Name] & " " & [Last Name] AS [Employee Name] FROM
Employees ORDER BY [First Name] & " " & [Last Name];
query used for form to show who is on call qryoncalllist
uses employees table
(Date criteria for employee for the week) Call:
([Forms]![frmautopayrollreport]![StartDate] And
[forms]![frmautopayrollreport]![EndDat])