Confusing Select/Theory

01-15-2004, 08:05 AM
For this problem, I have two tables:
(I am creating an employee scheduling app)

I have 5 different locations an employee can work at.
In tblEmployees I have 5 checkboxes, one for each location.

I have code in place that:
1 Gets a location
2 Gets a shift to be filled
3 Finds an employee to fill the shift

I am confused on how to select the employees.

'curLocation is the current location we are working with
"Select from tblEmployees Where x = ' " & curLocation & " ' "

My problem is 'x'. How do I make x, which is essentially check boxes = the current location?

Do I need to create another sub with a CASE that sets variables ?

01-15-2004, 08:15 AM
You will need some form of conditional branching to specify which field the WHERE clause will apply to.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum