If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Expression Builder
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 |
#2
|
|||
|
|||
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 "bbddvv" wrote in message ... 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 |
#3
|
|||
|
|||
On Mon, 14 Feb 2005 11:09:02 -0800, bbddvv wrote:
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 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. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
expression builder erased my expression | Stefano | General Discussion | 1 | December 6th, 2004 10:17 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
non-functional Expression Builder | Larry | Running & Setting Up Queries | 0 | August 26th, 2004 03:00 PM |
Expression Builder | Hai Le | General Discussion | 3 | August 13th, 2004 06:06 PM |