Syntax error in WHERE clause

[Dan A]

I have a button on a form which opens up a report. On my computer, and other
computers in my office, this button works just fine. However, when emailed
the file to an out of state coworker, she gets a "Syntax error in WHERE
clause" when she clicks on this button. I am unable to duplicate the problem
so I really don't know what could be causing it.

Does anyone know what may be the cause of this error, and why it would
happen on her computer and not mine? I built the source data for the report
from the query writing tool; I am new to SQL but from what I do know the SQL
statement looked fine.

 

[fredg]

I have a button on a form which opens up a report. On my computer, and other
computers in my office, this button works just fine. However, when emailed
the file to an out of state coworker, she gets a "Syntax error in WHERE
clause" when she clicks on this button. I am unable to duplicate the problem
so I really don't know what could be causing it.

Does anyone know what may be the cause of this error, and why it would
happen on her computer and not mine? I built the source data for the report
from the query writing tool; I am new to SQL but from what I do know the SQL
statement looked fine.

Do you think you could share her exact SQL with us?
And is that error message the 'Exact' and complete message.