How would I write a expression to select a specific quiry I have created then select the Column from that Quiry in one expression string,to show up in my report. The Report Datasource is a different quiry if that matters.

Quiry Name
ORG

Column
File As

I need to combine both into one expression.

Thank you

Hi,



What version of Access are you using? Please remember to select the version number when posting questions in case it becomes relevant to the discussion.

Check out the DLookup() function in Access Help. It allows you to pull data from an external table or query.

Just my 2 cents...

version 2010 and ok i will that a try thank you

Hi,



Good luck with your project. Let us know how it goes...