Check box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to create a query that shows a person's ID number if they did
not check a service date box. The table has a 32 fields total - 1 person's
id and the other 31 are 1 per service date. What I am trying to do is creat
the query so it displays the person's ID number if they did not mark any of
the service dates. Any assistance would be greatly appreciated.

Thanks
 
Instead of using Access, a relational database as a spreadsheet, I recommend
changing your data structure to this --
SvcID - Autonumber
ID - EmployeeID
SvcDate - DateTime datatype

Then you can check it real easy.
 
Ouch! Your structure is wrong, but if you are stuck with that table
structure you can add all the fields together and see if they total to 31.

Field: Abs(Check1 + Check2 + Check3 ... + check30 + check31)
Criteria: <> 31

If Access complains about too many parameters you can break the check
into two part

Field: Abs(Check1 + Check2 + Check3 ... + check15 + check16)
Criteria(1): <> 16
Criteria(2):


Field: Abs(Check17 + Check18 + Check19 ... + check30 + check31)
Criteria(1):
Criteria(2): <> 15


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top