Dlookup Assist

[Thompyt]

Where's my syntax wrong?



DLookUp("Netbase","Unit","[Units] =" & [TOE Title])


Table 1 Data
[TOE Title]

Table 2 UnitData
[Netbase]
[Units]

What my intentions are:
Look up the [Netbase] column value in the table named Unit where the Data table [TOE Title] column value is the same as the Unit Table [Units] column value.

I know [TOE Title] is not correct naming convention, but I didn't develop that structure. Its from an excel output from another database not under my control.

[aytee111]

It depends on the data type of the field [TOE Title]

If it is a text/memo/etc then you need quotes around it: "Units='" (single and double) & [TOE Title] & "'" (double/single/double) - translating into "Units='abc'")
As you have it above {TOE Title] is a number
For a date field it will be #

[Thompyt]

It was a string and it worked out I knew it had to do something with " and '

MUCH Appreciated!