Dlookup error

K

ker0k3n0

I hope you can help me with this issue. I am trying to do a DLookup function
to look up the Quarterly cap value from the Quarterly Cap table where
Customer Name match the name in the form:

=DLookUp("[Quarterly Cap]![Quarterly Cap]","[Quarterly Cap]","[Quarterly
Cap]![Customer Name]= '" & [Customer Name] & "'")

I receive an error:


I try to get replace , with ; or | it doesn’t like it.
When I click the expression builder I got this DLookup («expr»| «domain»|
«criteria») it asks for pipe but not happy.
 
D

Daniel Pineault

Since you specify the domain in the function, you need not specify it as part
of the other input variables, try:

=DLookUp("[Quarterly Cap]","[Quarterly Cap]","[Customer Name]= '" &
[Customer Name] & "'")

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
R

Roger Carlson

Did you name a field in your table the same as the table name? That's bad
practice.

I've not tested, but try replacing the bang (!) with a dot (.) like this:

=DLookUp("[Quarterly Cap].[Quarterly Cap]","[Quarterly Cap]","[Quarterly
Cap]![Customer Name]= '" & [Customer Name] & "'")

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
M

manuel camara

ker0k3n0 said:
I hope you can help me with this issue. I am trying to do a DLookup
function
to look up the Quarterly cap value from the Quarterly Cap table where
Customer Name match the name in the form:

=DLookUp("[Quarterly Cap]![Quarterly Cap]","[Quarterly Cap]","[Quarterly
Cap]![Customer Name]= '" & [Customer Name] & "'")

I receive an error:


I try to get replace , with ; or | it doesnâ?Tt like it.
When I click the expression builder I got this DLookup («expr»|
«domain»|
«criteria») it asks for pipe but not happy.
 

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

skype kenvort 0
Problem with my Dlookup 5
Calculating quarterly values from YTD values 5
Table/query layout trouble 2
DLookUp Function 11
DLookup 1
DLookUp 1
DLookUp for an Alphanumeric Record 3

Top