Syntax Error (Missing Operator) in Query Expression

I am getting this error.

Syntax Error (Missing Operator) In Query Expression. 'ProblemLogSearch.0[OccurenceDate at Customer]'

Any ideas on what is wrong?
ggodwinAsked:
Who is Participating?
 
chaauCommented:
ProblemLogSearch is most likely a table. There is a VBA code somewhere that has this error. If your data is not sensitive, or you can remove the data, you can try to upload your database here.
0
 
chaauCommented:
It would help if you provide the whole query. Most likely the '0' before the '[' is not required, like this:
ProblemLogSearch.[OccurenceDate at Customer]

Open in new window

0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
The 0 following the . before the bracket is not valid.

Maybe it should be:

ProblemLogSearch.[OccurenceDate at Customer]

Open in new window

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
ggodwinAuthor Commented:
How do I know which query it is in?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
0
 
ggodwinAuthor Commented:
My apologies guys I can't even find the query called ProblemLogSearch.
I am going through everything I got.
0
 
ggodwinAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.