J
John
I am trying to sum two fields of the same query.
Any one can help me?
Regards,
John
Any one can help me?
Regards,
John
John said:My apologie I want it to say 'Tables' instead of 'Reports'.
In this query, I want to create fields with the "Sum of
[field2]+[field2]and [field3]+[field3]:
Table1 |Table2
Field1|Field2|Field3|Field1|Field2|Field3|Units |Values|
xxx | 2.5| 3.0|xxxx | 2.5| 3.0| 5.0| 6.0|
------ + ------ = ------
...... + ...... = .......
I hope that it is now clear.
Regardsx,
John
-----Original Message-----
I am having trouble understanding this. Reports are based on queries rather
than "query of two reports". Maybe you should enter a few records into an
email and how you want them to appear so we can better help.
--
Duane Hookom
MS Access MVP
.