sum two fields of a query

  • Thread starter Thread starter John
  • Start date Start date
Yes.
Can you provide any more details or do we have to guess your field and table
names,...
 
It is a query of two reports.
The query consist 4 field where the first two are units
and the second are values. I want to create in the sema
query a 5d field which will sum up the two field with
values. How can I do that?
Thanks in advance.
-----John
 
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.
 
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
 
You can't have two fields in a report's record source that have the same
exact name. How are you doing this?
If they are different, try:
=Sum([Field2a]+[Field2b])
=Sum([Field3a]+[Field3b])

--
Duane Hookom
Microsoft Access MVP


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





.
 
Back
Top