I have started Access expert level 22 where a new database has been started to correct non relational data in an imported table. the first query ran correctly but when Richard built the 2nd query, I was unable to get it to produce the correct result. The Expression used in the query to obtain the latest address for each company left the Address:field empty when the Query ran. The DLOOKUP statement as written is Address: DLookUp("Address","Sheet1","Customer=""" & [Customer] & """ AND[Order date]=#" & [MaxOD] & "#") I am using Access 2007-2016
Kevin Robertson
@Reply 3 years ago
You are missing a space between AND and [Order date]
Alfred HandsOP
@Reply 3 years ago
I tried that but it made no difference thanks
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 22.
