building view help
I have table having the following
acc_name , date , debit ,credit
i need to build view as the following
acc_name , date , prev_balance,debit,credit,acc_balance
looking for your help
i have to do that urgent pls help me
I don't understand exactly what's the problem?
For example, what is the meaning of prev_balance and acc_balance?
thanks for your reply
prev_balance = previous balance before the accounting date
acc_balance = accumulative balance
hope it is clear
If you want to know what the syntax of a "create view" statement is, then you ought to know that and I don't think anyone on this forum will help you with anything so basic.
If you have a specific problem with creating the view e.g. there is some complex processing you want to do in it, then we may be able to help you. You will need to give more details on what the view is doing and why you are having a problem creating it.
acc_name date prev_bal debit credit acc_balance
XZ 01/01/06 1000 100 0 1100
02/01/06 1100 0 1000 100
this example of what i look for in my view
regards for all
for what I see:
acc_balance = prev_bal + debit - credit
is that right?
But, how do you calculate prev_bal?
The question cannot be answered on the basis of the information you have given. We will need to know:
a) what tables the view based on and how they join together
b) which columns in the table(s) are required in the view and whether they are named differently in the view
c) any special processing that needs to take place
one table same fields as mentioned above
where are the experts
is it too cmplicated
Click Here to Expand Forum to Full Width