Solved

Need help with a multi-criteria Dlookup

Posted on 2008-10-22
3
167 Views
Last Modified: 2013-11-27
I need to change the following:
Nz(DMax("[RFI_LN_NBR]", "[T_VMAC1_RFI_LINES]", "[RFI_PROJECT_IDENTITY_FIELD] = Forms![F_REQUEST_CONTACTS]![t_REQUEST_PHASE_ID] "), 0) + 1



To include the field "[RFI_SEQUENCE_NBR] = ME.T_RFI_NBR"  which is numeric.

How do I incorporate both criteria items into the DMax?  Thanks.
0
Comment
Question by:snyperj
  • 2
3 Comments
 
LVL 75
ID: 22779984
try this:

Nz(DMax("[RFI_LN_NBR]", "[T_VMAC1_RFI_LINES]", "[RFI_PROJECT_IDENTITY_FIELD] = Forms![F_REQUEST_CONTACTS]![t_REQUEST_PHASE_ID] "  AND [RFI_SEQUENCE_NBR] = " & ME.T_RFI_NBR"       ), 0) + 1

mx
0
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 22780017
Nz(DMax("[RFI_LN_NBR]", "[T_VMAC1_RFI_LINES]", "[RFI_PROJECT_IDENTITY_FIELD] = " & Forms![F_REQUEST_CONTACTS]![t_REQUEST_PHASE_ID] & " And [RFI_SEQUENCE_NBR] = " & ME.T_RFI_NBR), 0) + 1
0
 
LVL 75
ID: 22780071
oops .... I left out the &

oh well ...
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

808 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