Calculating payroll in access

[chegra26]

I have a database where I am tracking training activities for employees where different activities may be paid on different dates. For instance I have
(field, check box) 4 hr safety training (field, 4 hr pay date)
(field, check box) 2 hr safety training (field, 2 hr pay date)
(field, check box) SPED training (field, SPED pay date)
(field, check box) Paperwork (field, Paperwork pay date)

These activities can be performed on different days so therefore may have different pay dates
Is there any way within a query that I can create a calculation that will calculate only those activities where the pay date is blank.

 

[Chrisdontm]

I am not an Access expert, but I messed around with it and I couldn't get it to work, until....
I went back to the table that I was doing a query on, and I checked the field properties of the data type for the date column.
On the "required" setting I had it set on " No ".
Once I changed that to " Yes " and saved the changes, the query worked...

Oh, also, I used the ISNULL function as a criteria...
{ Notice for the expression I had to reference the table it came from and not the query itself...}
↓
(((IsNull([Vehicle ID]![State Registration]))<>False))

I hope that gets you there...

 

[Micron]

I have a database where I am tracking training activities for employees where different activities may be paid on different dates. For instance I have
(field, check box) 4 hr safety training (field, 4 hr pay date)...
These activities can be performed on different days so therefore may have different pay dates
Is there any way within a query that I can create a calculation that will calculate only those activities where the pay date is blank.

If the answer you got doesn't solve your issue, post back with information that is more concise and clear. You have all this stuf where? In tables? If so, "checkbox" fields as data or preferences is bad form and will likely cause you grief. You want to calculate what? All I got from your post was that you have "checkbox fields" and pay dates, so I don't see what there is to calculate. Even if you're referring to controls on a form, I still don't see what there is to calculate.