Calculation Problem Help Me

[mkkashif]

Dear Please Help Me it's urgent
i have table of following fields

Credit Debit Balance
200 0 200
0 10 190
0 20 170
100 0 270
How Can i Create like this Balance Sheet in Access.
How Can i create in Query or Form(DataSheetView) What Condition has to apply
to balance field.
How can i calculate the Balance Field As Showing .

 

[ssoltic]

In query you must create calculated fields (example balance1:Credit-Debit) and then you can create crosstabquery to show columns like balanced sheet. Or you can do this in continous forms (choose continous forms in form properties) and run calculation for Balance (on form put text fields for Credit and Debit and create text box for calculation). I hope thats you asking

 

[mkkashif]

Still have some Problem with Calculation

In query you must create calculated fields (example balance1:Credit-Debit) and then you can create crosstabquery to show columns like balanced sheet. Or you can do this in continous forms (choose continous forms in form properties) and run calculation for Balance (on form put text fields for Credit and Debit and create text box for calculation). I hope thats you asking

Dear
i have made the Query which have the followind field customerid,credit debit and balance.and also i created the continous form but problem is that which formula i apply to balance field in continous form.
or please help me to create cross tab query .i will be thankful to you

 

[ssoltic]

I dont now formula for calculating Credit or Debit. you can create Crosstab query with wizard if you click on new query. Even you can create a continous form based on your existing query (egg. create textbox named txtDebit, control source is Debit form query, create textbox named txtCredit control source is Credit, and finaly you must create textbox call him txtBalane and for control source enter "=Debit-Credit" without quotes, also you can enter names of textboxes). I repeat I dont now wich formula is used for calculating balance. I dont understand, you have a table with fields (credit, debit) did you input value for balance or balance is calculated field based on credit and debit. If so you dont need to have balance field in table, let access to calculate. hope this help