requet for form an access query for report

[JK Dutta]

I have an access table consisting of four field as detailed below:
Table Name : "SBTrans"
Fields are:
TransID: Date: Debit: Credit:

I want to extract a report in the following format:
TransID Date OpeningBalance Debit Credit ClosingBalance

May I request you to kindly help me to draw a access query
Thanks

JK DUtta

 

[Andrzejek]

What have you tried so far....

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[dhookom]

JK,
Can you provide a sample of data and desire result? Where does the beginning balance come from?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016