Having Expression Builder troubles - HELP!!!!!!!!

[ADencklau]

I am trying to use the expression builder to pull in information from more
than one table or query onto a report. I insert a text box, open the
properties window and select the data tab. For the control source, I click
to open the expression builder and click = then double click my table and the
field I want to display. When I preview my form it pops up with a Enter
Parameter value. Nothing I enter pulls the value in, it gives me an error.
Can anyone help???

 

[Jeff Boyce]

First, are you using the "lookup" data type in any of the tables in
question... it can cause problems like the one you described.

Next, to join tables together, use a query, not the expression builder.
Then use THAT query as a source in a subsequent query.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ADencklau]

Yes, I do have lookups in the tables that I trying to join. My biggest
problem is that there are a lot of fields to pull together into one report
and a query will not allow me to select all the fields I need.
Any other suggestions?

 

[Jeff Boyce]

If your report needs more data than what you can put into a query, maybe you
could create more than one report, based on sub-sets of the data, and use
sub-reports embedded in a main report to see it all.

Regards

Jeff Boyce
Microsoft Office/Access MVP