cell formatting

[Guest]

I have just run a query in which i have performed a calculation. The number
that results are all in decimal format and look like the following,
2345.121343. Is there a way to format the cells like in excel to remove the
decimals making the number look like 2345 . Or is the only way to do that
by exporting it to excel. This is what I was to try to avoid as in the
future less experienced access users will be using the database. Thank you
very much in advance
laurent

 

[Joseph Meehan]

I have just run a query in which i have performed a calculation. The
number that results are all in decimal format and look like the
following, 2345.121343. Is there a way to format the cells like in
excel to remove the decimals making the number look like 2345 . Or
is the only way to do that by exporting it to excel. This is what I
was to try to avoid as in the future less experienced access users
will be using the database. Thank you very much in advance
laurent

Go to design view chose the column and then chose properties format and,
If I remember set fixed and 0 decimals

 

[Guest]

Few options:
Round(MyNumber)
Format(MyNumber,"#")
Int(MyNumber)