Rounding problem

[jgelpi16]

This appears to be a simple fix/problem, but I am going crazy trying to figure it out. I have a query that calculates a percent. When I pull this query into my SQL statement to display on my form the number gets rounded. I do not want that. I have checked everywhere. None of the percentage fields are formatted to percent, they are all "blank" in the format field. When I open the query the number is not rounded. Any suggestions? I am using 2007 and I know in previous versions you could check the "Orders and Grouping" setting, but I can't seem to find that in 2007.

[SoftwareMatters]

Try checking the datatype in the table's design view. You need to specify that it is a number and change the FiedlSize and DecimalPlaces accordingly.

This might be useful: http://msdn.microsoft.com/en-us/library/bb208866.aspx