Results based on 2 expressions

[jk]

I have the expressions below which work but now i need a second expression
based exp1 which would subtract amount entered into
Transactions.WithdrawalAmount field. Can this be done?
exp1: [DepositAmount]*1.03-[DepositAmount]

 

[Duane Hookom]

Try:
NewBetterName[DepositAmount]*1.03-[DepositAmount])-Transactions.WithdrawalAmount

 

[jk]

Thanks Duane,

This worked and i would like to know how to edit the expression since i have
four customers which have a different percentage like 3%,2%, 4%,6%. Would i
need to create a separate query for each cusID using the two expressions?

Try:
NewBetterName[DepositAmount]*1.03-[DepositAmount])-Transactions.WithdrawalAmount
--
Duane Hookom
Microsoft Access MVP

I have the expressions below which work but now i need a second expression
based exp1 which would subtract amount entered into
Transactions.WithdrawalAmount field. Can this be done?
exp1: [DepositAmount]*1.03-[DepositAmount]

 

[Duane Hookom]

Create a [CustPct] field in your customer table. Enter the appropriate
percentage into the new fields and use this field in your expression:
NewBetterName[DepositAmount]*[CustPct]-[DepositAmount])-Transactions.WithdrawalAmount
--
Duane Hookom
Microsoft Access MVP

Thanks Duane,

This worked and i would like to know how to edit the expression since i have
four customers which have a different percentage like 3%,2%, 4%,6%. Would i
need to create a separate query for each cusID using the two expressions?

Try:
NewBetterName[DepositAmount]*1.03-[DepositAmount])-Transactions.WithdrawalAmount
--
Duane Hookom
Microsoft Access MVP

I have the expressions below which work but now i need a second expression
based exp1 which would subtract amount entered into
Transactions.WithdrawalAmount field. Can this be done?
exp1: [DepositAmount]*1.03-[DepositAmount]