Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Dlookup and where condition

Posted on 2016-10-02
3
Medium Priority
?
60 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 53

Accepted Solution

by:
Rgonzo1971 earned 2000 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

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…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

610 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