building view help

[hsbdba]

Hi,

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

regards

[hsbdba]

i have to do that urgent pls help me

[jvalerof]

Hi,

I don't understand exactly what's the problem?
For example, what is the meaning of prev_balance and acc_balance?

[hsbdba]

Hi jvalerof,

thanks for your reply

prev_balance = previous balance before the accounting date
acc_balance = accumulative balance

hope it is clear

[Scorby]

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.

[hsbdba]

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

[jvalerof]

Hi hsdbda,

for what I see:

acc_balance = prev_bal + debit - credit

is that right?

But, how do you calculate prev_bal?

[Scorby]

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

[hsbdba]

very simple

one table same fields as mentioned above

reagrds

[hsbdba]

where are the experts

is it too cmplicated