Dlookup error

[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.

 

[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.

 

[Daniel Pineault]

Also, on a side note, you may wish to add the ELookUp function to your
repertoire to replace the DLookUp function. There are a number of reason to
do so and the are discussed on the following page:

http://allenbrowne.com/ser-42.html
--
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.

 

[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

 

[manuel camara]

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.