Solved

Dlookup and where condition

Posted on 2016-10-02
3
44 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 50

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

696 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