How do you multiply a Currency and a number?

[NeoZakz]

This should be pretty simple but its just not working for me. Im just trying to multiply a cost * Days type thing and get a total in a query, But it isnt putting anything at all. What command do you use in a query to multiply stuff together?

 

[raskew]

Something like: MyCost * NumDays as MyTotal

 

[dschomburg]

Are these fields in the same table? How is your query set up ?
This should be straight forward. Unless they are from different tables with no join or there is a null.

Example from the same table;

ResultField: ([Amount] * [Days])

If the fields are from different tables, how are they joined?