Search results

Hello. I have a form based on a query which gets the current month's value and uses it in the form to calculate a field. This is a multi-user database. and I have to remember to go into the database on the first of the month to change the query field used in the form calculation. I am...

That did it! Seems like because there is a lookup to convert the Option Group number, It seems to be saving the text. Thanks June7!!

Thanks for your offer June7. Just too much confidential data to clean out. If [Pay_type] were text how would that change the expression?

My mistake it is Employee_Number. Same mismatch error after adding single quotes as you suggested.

When I entered the syntax offered by June7, I got the error "Data Type mismatch in criteria expression" ="[pp_end_date]=#" & [pp_end_date] & "# AND [Employee ID] = " & [Employee ID] & " AND [Pay Type]=" & [Pay Type] Looking at the Macro error window, the argument is: Comments 21, Form, ...

The table shows text, but to get a conditional format to work I had to use the number, 1 or 2 for State or OSHA.

I am trying to open a Form using a command button on an exiting form. One condition is based on a date field, one on a text field and the other on a text field saved from an option group. Not sure whether to use the looked-up text or the numeric value for the option group field value. Using the...