This is a really basic question. I am taking a teach yourself
beginners course on Access 2003 and have run into a road block on one
practice. In a select query, I have created a simple calculation
field.
Markup:([Price]-[Cost])/[Cost]
which is to formatted as Percent with 0 Decimal places.
When I click into the Format box is am offered
Description...................
Format........................
Input Mask...................
Caption........................
Smart Tags..................
But..... no Decimal Places
My text and everything I have tracked down online indicates that
decimal places should be in that format box...
When I run the query the values in the table are all okay except that
the values in the Markup column are percentages with 2 decimal places.
What little something am I overlooking?