Standard with no decimal places

[RamziSaab]

is there a way to have the format set to standard (e.g. i want the comma). But i dont want any queries to come up with decimal places...(if i put the decimal property to zero on the table design they still show up in queries??)

 

[hymn]

Do they show up after you made the format standard and the decimal place 0 or records prior to that

Hope this helps
Hymn

 

[RamziSaab]

after i used a code to round off all number to zero decimal places first then i change to standard??

 

[SgtJarrow]

You can set the display properties of each field in the query.....open the query in deisgn mode, right click on the field in question, select properties. You will find the format properties...set them to standard and zero decimals.

If that doesn't work, you can also use the following:

In the query in design mode, find the field in question. If the field line, change:

Field Name

to

Format([Field Name], "#,##0&quot

this will format the field to standard format without the decimals...

****************************
Only two things are infinite, the universe and human stupidity,
and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com

 

[RamziSaab]

This is for an end user so i would prefer if there was a way to do this automatically?? I have a form that builds a query now i can go to the sql and put Round(...,)
but i am sure there is a way to tell access never to display decimals EVER!!

 

[hymn]

If you go into your table
the field with the Number
format = standard
decimal places = 0

and numbers after this update should be as you require

Hope this helps
Hymn

 

[RamziSaab]

hymn: that is true but the queries still show two decimal places!!!!