Plz help! Query for Summing individual records on their own

[rezza]

Hello Everyone,

I am trying to perform a sum of records for the table below

SeatType | Ext rent | |Internal rent |
Work Transfer 2 2
Vendor
Other 2 3
LOB BRF
GTI BRF 2 5
Displacement


so that when I run the query I get the following following


SeatType | Ext rent| |Internal rent| | Total |
Work Transfer 2 2 4
Vendor
Other 2 3 5
LOB BRF
GTI BRF 2 5 7
Displaceme


What I mean is that from the first table how is it possible to get the results below. The query would generate a new column and place the sum of the data in the each row(record) in the same row in the total column. I would be really grateful. Have been bashing my head all day over this. PS I dont know any VBA. Is it possible without VBA?

Thank you.

 

[Malcy]

Open your query in design view and in the first empty column on the right hand side enter Total: [Ext rent]+[Internal rent] assuming those are your field names
This should give you the result you want I think
Good luck

 

[rezza]

Open your query in design view and in the first empty column on the right hand side enter Total: [Ext rent]+[Internal rent] assuming those are your field names
This should give you the result you want I think
Good luck

Thanks for reply. I already did that in office but that gives the total in one row of everything. I need sum for each record in its related row. that is not done with this formula. Anything alse u know thanks.

 

[RV]

I need sum for each record in its related row

Not sure what you're after then.
Post your current query.

RV

 

[rezza]

Not sure what you're after then.
Post your current query.

RV

Table from which query would be run

SeatType | Ext rent | |Internal rent |
WT | 2 | | 2 |

Other |2 | | 3 |

so that when I run the query I get the following following table


SeatType | Ext rent| |Internal rent| | Total |
WT | 2 | | 2 | 4 |

Other |2 | | 3 | 5 |


Hope this simplifies the quesition. In the 1st row the 2 and 2 belong to 2nd and 3rd column which are Ext rent and Internal rent respectivelya nd producing a 4 as a result of query. second row 2 and 3 belong to 2nd and 3rd column and sums to 5 in the total column. All this should be the result of a query performed on the table above this table which is without the total column.

thanks

 

[RV]

Hope this simplifies the quesition.

Not really.
You do need to post your current query.

RV