Les,
You're probably getting a good chuckle out of this because you realize what is causing the word "Error" to show up whereas I had to think it through. Therein lies the difference between a pro like you and an amateur putz like me. [tongue]
Thanks again for your help.
LesPaul,
Soooooo close.... I had to close the parentheses around([A]) to stop the nag about it and then my results were good except for an "Error" next to an employee's name. I looked at the db and could see no overt anomaly with the record. Running out of time...will continue researching...
I have a query that concatenates the name of a staff member with the results of either of two check boxes.
Check box [AOT] indicates that staff member [A] worked overtime. Check box [ATRD] indicates whether that staff member worked a trade for someone else.
The statement ([A]) & " " &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.