calc a field based on values for example if [acnt_nbr] in 300999,.

W

Wilbert

I am trying to calculate a field called Net_profi. Net_profirt is based on a
series of accounts. For example

Net_profit= account nbr 399000, 400000, 500000 520000 530000

if account in(399000, 400000, 500000 520000 530000) net_profit= acc_bal =
the value of the found account.

Thanks for your response in advance
 
J

John Vinson

I am trying to calculate a field called Net_profi. Net_profirt is based on a
series of accounts. For example

Net_profit= account nbr 399000, 400000, 500000 520000 530000

if account in(399000, 400000, 500000 520000 530000) net_profit= acc_bal =
the value of the found account.

Thanks for your response in advance
Click to expand...

I'm not at all sure what you mean here.

Could you just Join this table to a table with account numbers and
account balance?


John W. Vinson[MVP]
 
W

Wilbert

Vince,

Thanks for replying to my email. The post did not answer my question. Here
is what I am tring to do.

As I indicated before, I have to calculate a field called Net_Profit and
display on a report. Net profit is based only on certain account numbers. My
file has many account numbers, but Net_profit can only be calculated using
these few specific accounts.

In plain English, I would say it like this.

Net_profit = If account_nbr in(399000, 400000, 510000, 520000, 520300,
520500) then add Account_bal to the Net_profit bucket

I hope this is clear.

Thanks
Wilbert Laurent
 
Top