**HELP **

L

Lightning Zeus

Can i in the same expression sum two fields for the first record and sum
other field for the other records. I need to sum an amount only for the first
record and then maintain a running sum for the others records. is this
possible ** HELP **
 
J

John Vinson

Can i in the same expression sum two fields for the first record and sum
other field for the other records. I need to sum an amount only for the first
record and then maintain a running sum for the others records. is this
possible ** HELP **
Click to expand...

You'll have to explain your table structure.

There is no such thing as a "first record" in a Table. All records
have the same "rank"; a Table should be considered as an unordered
heap of data, not as a linear list.

If you could give an example of your table structure and what you're
trying to do with it, someone should be able to help - but since we
cannot see your database nor understand your business need without a
clear explanation, it's hard to advise!

John W. Vinson[MVP]
 
L

Lightning Zeus

i have a table with 4 coluns (date,descripton,debit,credit), in the the
report i have de same coluns plus another that is the balance
([debit]-[credit]). the problem is when i ask for a report limited for
example for 1 month the balance is never correct because access is only doing
the sum in that month. how can i resove this...

"John Vinson" escreveu:
 
Top