Expression Builder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my database i have two tables, a seperate query built from each table, and
a single report. In the report I am trying to build an expression that adds
a value from quesy 1 to another value from query 2. Access will not let me
do this. I need to make this calculation but i continually get error
messages. Help please. Thanks
 
What is the data source of your report? Are you pulling both queries into
your SQL behind the report? That would be the only way that I would know to
use data from both queries. I'm assuming there is some common field in
these two queries so you can build a proper relationship?


Rick B
 
In my database i have two tables, a seperate query built from each table, and
a single report. In the report I am trying to build an expression that adds
a value from quesy 1 to another value from query 2. Access will not let me
do this. I need to make this calculation but i continually get error
messages. Help please. Thanks
Click to expand...

Why not make a 3rd query, using the 2 you already have, and add a
column in the query doing the calculation? Use this query as the
report record source.
If for some reason you cannot, then you can use DLookUp:
=DLookUp("[FieldA]","QueryA") + DLookUp("[FieldB]","QueryB")
You may need to add criteria to each of the above expressions, so that
Access knows which record to address.
 
Back
Top