Syntax Error (Missing Operator) in Query Expression

It would help if you provide the whole query. Most likely the '0' before the '[' is not required, like this:

ProblemLogSearch.[OccurenceDate at Customer]

Select allOpen in new window

The 0 following the . before the bracket is not valid.

Maybe it should be:

ProblemLogSearch.[OccurenceDate at Customer]

Select allOpen in new window

How do I know which query it is in?

How do I know which query it is in?

What are you doing when the error occurs? You can generally track down the culprit by following your code.

To do that, set a breakpoint in the code, then "run" the process that causes the error. When Access hits that breakpoint, you'll be thrown into the Code Editor window, and you can use the Debug commands to move through your code.

To set a breakpoint, open the code window and place your cursor in the line of code where you wish to set the breakpoint. Press the F9 key. The line will be highlighted in Red.

When you reach the breakpoint, you can "step through" your code by pressing the F8 key. This moves you one line at a time. When you hit the line that causes the error, you'll see that error message.

Here's a good article about debugging in Access: http://support.microsoft.com/kb/108438

My apologies guys I can't even find the query called ProblemLogSearch.
I am going through everything I got.

I've requested that this question be deleted for the following reason:

The database was missing many items. I found it easier to start over. When I did the problem in this question was resolved.