By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,649 Members | 1,808 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,649 IT Pros & Developers. It's quick & easy.

Can't change decimal places in format box.

P: n/a
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?

Feb 12 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Do this. create the query including your calculated field.
Format the calculated field (highlight field column, right click, format,
set as a percentage.
run your query. Go back to design view. Highlight field column. Right click
for properties and by magic the decimal property is there. Don't know why
that is - it just is.

"hunslair" <hu******@pldi.netwrote in message
news:11**********************@s48g2000cws.googlegr oups.com...
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?

Feb 12 '07 #2

P: n/a
On 12 Feb 2007 13:20:36 -0800, hunslair wrote:
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?
Markup:Format([Price]-[Cost])/[Cost],"#%")

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Feb 13 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.