sum two fields of a query

[John]

I am trying to sum two fields of the same query.
Any one can help me?

Regards,
John

 

[Duane Hookom]

Yes.
Can you provide any more details or do we have to guess your field and table
names,...

 

[John]

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

 

[Duane Hookom]

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.

 

[John]

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

 

[Duane Hookom]

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

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





.