I have made several different queries with calculated fields on them and they work almost properly. What I need to know, is how to assign a data type to the calculated expressions. For instance, I have a field in the table with a currency data type and on the query I do a calculation on it to add a markup. When I open the query the calculated value is correct but it's just an integer with no currency symbol and no decimal places. That means that where the calculation results in a value that has say 50 cents, it won't show, so the calculation is then incorrect for my purposes.
Thanks in advance for your help.