i have table ratemoney in database
TBLRatemoney
Rate_Name char 10
Rate_Money money
Select * from TBLRatemoney
USD 1
EUR 2
in report i want to show it
USD 1 200(1*200)
EUR 2 400(2*200)
do you understand me?
Printable View
i have table ratemoney in database
TBLRatemoney
Rate_Name char 10
Rate_Money money
Select * from TBLRatemoney
USD 1
EUR 2
in report i want to show it
USD 1 200(1*200)
EUR 2 400(2*200)
do you understand me?
What u want as output? Do you want to calculate like 1* 200 or whatever ?
if you only want to show the calculation then create a function and multiply it something like this.
Code:Rate_Name & Rate_Money * 200
No i want to show in my report
In report have function?