Report field: Pull data from different table based on value in different field

[fsask2013]

Haven't done much with Access in a long time.

I have a Report that I want to add a field to. It's a text box meant to display some data from a different table other than the one the Report is tied to.

The table is use is called "PrimaryData" and the second table is called "NamesOnly"

Both tables have a field called "Username" and the second table only has a field called "Companyname"

I want this Report box to display the value (it's a string..) of Companyname from the second table, based on what the Username is.

I think the basic idea for the text box Control Source is:

=[NamesOnly]![Companyname]

but how to specify the condition, "WHERE the Username on the same record determines which [Companyname] to display..."

Sorry if this is unclear. I have some decent experience with SQL, but am really not familiar with how to express this stuff in Access.



TIA for your suggestions!

[ketbdnetbp]

fsask2013 -

Assuming [Username] is text and the field [Username] is in the NamesOnly table?, you could try something like...

=Dlookup("[CompanyName]","NamesOnly","[Username]= '" & Me![Username] & "'")

All the best,

Jim

[fsask2013]

Thank you, I'll try that approach. I temporarily solved the problem by running modifying the large Excel file that I imported into the Access table for the data. I'd prefer the Access-only route, as I feel that maintaining 2 Access tables is simpler than having to deal with the Excel sheets.