Dlookup in Query

[Dave]

Need help with the criteria portion of a Dlookup.
This dlookup is in the "Field" portion of a query.
The query is a single table query pulling from the orders table.
There are reasons I can't pull other tables into this query.
I am trying to pull in the customer name(not in the "Orders" table) for
each "order" in the Order List this Query is generating.

I just don't know how the syntex of the criteria is written.

FirstName:dlookup("CustomerFirst","tblCustomers","")

Thanks in advance,

D

 

[John W. Vinson]

Need help with the criteria portion of a Dlookup.
This dlookup is in the "Field" portion of a query.
The query is a single table query pulling from the orders table.
There are reasons I can't pull other tables into this query.
I am trying to pull in the customer name(not in the "Orders" table) for
each "order" in the Order List this Query is generating.

I just don't know how the syntex of the criteria is written.

FirstName:dlookup("CustomerFirst","tblCustomers","")

Thanks in advance,

D

You don't give any indication what fields exist in your orders table or in the
customer table which would provide a link, so I'll make a plausible guess that
you have a CustomerID field in each.

The third argument to any domain function is a String which evaluates to a
valid SQL WHERE clause without the WHERE. So if you have an order selected for
customer 3161, the third argument should be

"[CustomerID] = 3161"

YOu can build this string up from pieces by concatenating string literals (in
quotes) with values from the other fields in the query:

DLookUp("[CustomerFirst]", "[tblCustomers]", "[CustomerID] = " & [CustomerID])

The first customerID - in quotes - is a text literal referring to the field in
tblCustomers; the second is a variable referring to the CustomerID field's
value in the order table.

John W. Vinson [MVP]

 

[Dave]

Yep John - That was just want I needed.
Sorry about the lack of details.

Thank you.
D

Need help with the criteria portion of a Dlookup.
This dlookup is in the "Field" portion of a query.
The query is a single table query pulling from the orders table.
There are reasons I can't pull other tables into this query.
I am trying to pull in the customer name(not in the "Orders" table) for
each "order" in the Order List this Query is generating.

I just don't know how the syntex of the criteria is written.

FirstName:dlookup("CustomerFirst","tblCustomers","")

Thanks in advance,

D

You don't give any indication what fields exist in your orders table or in
the
customer table which would provide a link, so I'll make a plausible guess
that
you have a CustomerID field in each.

The third argument to any domain function is a String which evaluates to a
valid SQL WHERE clause without the WHERE. So if you have an order selected
for
customer 3161, the third argument should be

"[CustomerID] = 3161"

YOu can build this string up from pieces by concatenating string literals
(in
quotes) with values from the other fields in the query:

DLookUp("[CustomerFirst]", "[tblCustomers]", "[CustomerID] = " &
[CustomerID])

The first customerID - in quotes - is a text literal referring to the
field in
tblCustomers; the second is a variable referring to the CustomerID field's
value in the order table.

John W. Vinson [MVP]