DLookup in Query Problem

Topic

New Reply

Having a problem with following DLookup in Query, I’ve tried the following three variations without success, please help with proper Query/DLookup syntax

Union Status is a text field in the query

Union Desc: DLookUp(“[Description]”,”[Union Statuses]”,”[Code]= [Union Status]”)
Error: The expression you entered as a query parameter produced the error: ‘Microsoft Access can’t find the name ‘Union Status’ you entered in the expression’

Union Desc: DLookUp(“[Description]”,”[Union Statuses]”,”[Code]= Union Status”)
Error: Syntax error(missing operator) in query expression ‘[Code]= Union Status’.

US: Union Status is a text field in the query

Union Desc: DLookUp(“[Description]”,”[Union Statuses]”,”[Code]= US”)
Error: The expression you entered as a query parameter produced the error: ‘Microsoft Access can’t find the name ‘Union Status’ you entered in the expression’

Reply | Quote

Replies

doctor9, UtterAccess Editor, provided the following solution:

Try this:

Union Desc: DLookUp(“[Description]”,”[Union Statuses]”,”[Code]='” & [Union Status] & “‘”)

If your [Code] or [Union Statuses] field values can contain apostrophes we’ll need a slight variation.

Hope this helps,

Dennis

Reply | Quote