Reference a field value specific to a record in a query?

[eepok]

Hey all, again,

Situation:

"Table1" <-- Data Entry storage
Record 1: FieldA, other stuff, other stuff, FieldB, more stuff, more stuff
Record 2: FieldD, yadda, yadda, FieldA, etc, etc

"Table2" <-- Field Data Source
Record 1: FieldA, Adata1, Adata2
Record 2: FieldB, Bdata1, Bdata2
Record 3: FieldC, Cdata1, Cdata2

Needs:
I'm making a query for a report and I figured out that I don't know how to reference a specific record's field in another table. What I need to be able to do is pull up the value of "Adata2" in the query if "FieldA" is the value for a field.

That's easy enough, no?

 

[Alc]

Not sure exactly what you need, but could you use DLookup() in the report field?

 

[eepok]

Not sure exactly what you need, but could you use DLookup() in the report field?

Thanks for reading through my rather jumbled description. That looks like it does exactly what I need. I was in the middle of re-writing the whole thing when you replied! =P

(4 wisdom teeth extracted recently = no coffee = crazy typing)

 

[Alc]

Thanks for reading through my rather jumbled description. That looks like it does exactly what I need. I was in the middle of re-writing the whole thing when you replied! =P

(4 wisdom teeth extracted recently = no coffee = crazy typing)

Glad to help. Good luck with it.