Solved

Dlookup and where condition

Posted on 2016-10-02
3
37 Views
Last Modified: 2016-10-02
Hello, I have an error at the end of the statement.  I need to return or [AvailableUSD_Equiv] for where FACID = 16.  I have tried brackets, quotes and no quotes or brackets and with an with the "&" as well.  Ran out of options.  
Thank you for the help.  

=DLookUp("[AvailableUSD_Equiv]","QryBal2_Works","[FacID]=" 16)


thank you
0
Comment
Question by:pdvsa
3 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 41825564
Hi,

pls try
=DLookUp("[AvailableUSD_Equiv]","QryBal2_Works","[FacID] = 16")

Open in new window

Regards
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 41825567
Try

=DLookUp("[AvailableUSD_Equiv]","QryBal2_Works","[FacID]= 16")

I assume that FacID is a numeric datatype - check it's source table in the query. If a test datatype then it would be

=DLookUp("[AvailableUSD_Equiv]","QryBal2_Works","[FacID]= '16'")

Kelvin
0
 

Author Closing Comment

by:pdvsa
ID: 41825572
perfect.  thank you.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question