DLookup Only Shows 1 Rec - Microsoft Access Expert 22


	Back to Access Expert 22 Comments List

Upload Images @Reply Bookmark Link Email

DLookup Only Shows 1 Rec

Elena Chiozza

2 years ago

In the first lesson, after following step-by-step the buiding of the DLOOKUP query, when I run it, it only shows data (Address and Phone) for the first record. Why might that be?

	Richard Rost @Reply 2 years ago
Because that's exactly what DLookup does. It returns ONE record.

	Elena Chiozza OP @Reply 2 years ago
Thank you Richard, but in your video you didn't have to do anything else to make the other two appear, how do I fix it? Thank you!:)

	Richard Rost @Reply 2 years ago
Which video, and at what time index? It's been YEARS since I recorded this. :)

	Elena Chiozza OP @Reply 2 years ago
Sure, of course, it's the Access Expert 22, Lesson 1, about 13min in:)

	Kevin Robertson @Reply 2 years ago
Elena, Can you share the exact DLookup function you used in the query. Also, make sure the Return box on the Ribbon says All

	Richard Rost @Reply 2 years ago
If you're only getting one record from the query, then it's probably not the fault of your DLookup statement. Do you see multiple records BEFORE you put the DLookup statement in there?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 22.