Dlookup (1 Viewer)

T

TobyMace

Registered User.

Local time

Today, 00:52

Joined

Apr 13, 2018

Messages

65

• Jun 15, 2018

• #1

Hi all,

I want to look up the value of [A] and return all values of that has that value of [A] against it. However I don't want to define the value of [A] myself each time. I want it to look the value up from existing records and each time I add a new one then display them in a subform/datasheet?
So I could have 5 records where [A] = 5 but all 5 records will have a different value in ( does not allow duplicates). If all 5 records having a subsheet showing all 5 previous entries then that's fine.
How would I go about doing this?

Make any sense at all?

Thanks.

 

Minty

AWF VIP

Local time

Today, 00:52

Joined

Jul 26, 2013

Messages

10,371

• Jun 15, 2018

• #2

Not clear at all.
Can you make up a picture if this is for a form and/or better still some sample data.
Please include
A) Source data, enough to cover all eventualities.
B) What you expect to see as a query result.

 

The_Doc_Man

Immoderate Moderator

Staff member

Local time

Yesterday, 18:52

Joined

Feb 28, 2001

Messages

27,172

• Jun 15, 2018

• #3

A SELECT query would do this if everything is in the same table.

The question would be how you select [A], and there is where your description becomes very vague. That would be critical to the process, so I'm with Minty. We need to know at least a little bit more than you gave us.

 

T

TobyMace

Registered User.

Local time

Today, 00:52

Joined

Apr 13, 2018

Messages

65

• Jun 18, 2018

• #4

Hi guys,

Thanks for help. I was able to find a solution myself over the weekend.
Apologies for wasting your time!

Kind regards.