471,337 Members | 941 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

Can't change decimal places in format box.

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
2 6802
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
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.

Similar topics

2 posts views Thread by Hank | last post: by
8 posts views Thread by nick | last post: by
1 post views Thread by martin | last post: by
11 posts views Thread by MikeY | last post: by
3 posts views Thread by paulquinlan100 | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.