Missing operator in query, DLookUp()

[dago87]

Hello.
I have following function in my query

DLookUp("name","Q[-]shortages","Q[-]shortages.ItemNumber='" & [PartNumber] & "'") AS Facility

I'm getting an error: Syntax error (missing operator) in query expression: 'Q[-]shortages.ItemN umber=1010'"

Q-shortages is another query, it's not table.

I really don't know what may be wrong.
Thank you for any help

[PhilOfWalton]

If PartNumber is numeric, you don't need the extra single quotes, if it is text,you do need them.

I would be very very very suspicious of how Access would handle those square brackets in Q[-]shortages. Change the name of your query simply to QShortages. Square brackets are normally used to indicate that 2 words are to be treated as one, so you can't use Last Name, but you can use [Last Name]

Sorry to go on, but "name" is a reserved word, and should not be used as the name of a field in any table. Don't know what you are after but FacilityName is perfectly acceptable.

Another reserved word that frequently causes trouble is "Date"

DLookUp("FacilityName","QShortages","ItemNumber=" & [PartNumber]) AS Facility

[dago87]

Thank you for fast reply, but sadly none of your suggestion have helped.
PartNumber is text field.
There has to be error somewhere in those double/single quotes.

[B]'[/B]Q[-]shortages.ItemNumber=1010[B]'[/B]"

[PhilOfWalton]

You haven't got rid of those square brackets

Phil

[PhilOfWalton]

Try

DLookup ("Name", "QShortages", "ItemNumber = " & Chr$(34) & PartNumber & Chr$(34))

Chr$(34) is always much clearer than a string of single & double quotes

Phil

[NeoPa]

@Dago.
Your code and the error message simply don't match. One of them must be wrong.

Please check the details of your question before posting.

Please update the question with the correction(s) required.