How to make a query that returns different criteria.

[JPaulo]

Hi All;

How to make a query that returns different criteria.

My table “tblRelease”
Fields:
Account - text data
OpeningBalance- Currency
Type - Combo box – Value list = credit / debit
Status - Combo box – Value list = Pg / Pg no

I would get the momentary balance, ie credits and debits paid and unpaid balance added to the initial and the actual balance, ie credits and debits paid added to the initial balance.

 

[pbaldy]

I'm not clear on what you're trying to achieve. Further, I wouldn't store an opening balance, and there doesn't appear to be a date or ID field that would let you order the data. Can you show some example data and what you'd like to see based on that data?

 

[JPaulo]

Sorry, resolved with the DSUM function in form.

Thanks for replay