Syntax error(missing operator)

S

Supe

I have a form where you enter a UPC or multiple UPC in a list box and it find
stores that have not ordered that item. Works fine on the database it was
created on. I copied this form(and all the tables, queries that go with it)
to a new vendor database. Now it only works if I enter more than one UPC. I
get the error message below if I enter only one UPC:

Run-time error '3075'

Syntax error(missing operator) in query expression[All in one store
reference] LEFT JOIN [Riviana Master] ON [All in one store reference].[Store
Num] = [Riviana Master].CustNbr LEFT JOIN [Week Numbers] ON [Riviana
Master].[Invoice Week] = [Week Numbers].[Wk#]

Any idea why it would work on one database and not the other? Only change I
made to the code was changed the table name from Bayer Master to Riviana
Master
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text vs Numeric error 3
copy paste but not keying in works 1
Excel does not accept text format! 0
Syntax error 3075 missing operator 12
Only enter a certain number of values in a text box? Access 2000 5
Go to same Record/ Syntax Error 8
Not in List syntax error 2
Run-time error 80040e14 (Missing Operator) in '% ... Writer's Choice .... %" 2

Top