Question about numbers in a field

[hrbsh97]

Hello,

I have a field that is specific for numbers only .. here is the problem I am
having .. for example if I put in 15.5 .. it rounds it out to 16 .. 17.5 ..
18 and so on .. how do I format the field so that it will stay at the number
I originally put in?

Many thanks!

 

[boblarson]

Go into the table in design view and change the datatype from Integer (or
Long Integer) which you currently have to one of these three datatypes:

1. Single
2. Double
3. Decimal
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[hrbsh97]

Thanks for the quick reply .. simple to follow instructions and I appreciate
the answer. Also, is there an easy way to total data in Access .. I know
Excel and can do formulas .. is it the same concept? ..

 

[boblarson]

Yes, you can do totals; not in the tables (most of the time you don't want to
store calculated data in the tables, if the parts exist where you can create
the calculation at any time).

You can do it in a query, form or report. It all depends on what you are
wanting to display: where and when.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[hrbsh97]

I would actually want to display it in my report .. are the formulas the same
as Excel? .. also, one other question as you are so good at this .. I am
trying to do a query based on my personnel database .. is there a way to do a
query that would query ONLY fields that have data in them? .. for example ..
I want ONLY the fields that have email addresses in them ..

Thanks for all your help ..

 

[boblarson]

Yes, in the criteria for the email field you would put

Is Not Null

to get all records where there was an entry in the email field.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[George Nicholson]

Not to be picky, but the Datatype would remain Number. The FieldSize would
change from Integer/Long integer to one of your 3 choices.

Or change the Datatype to Currency (w/no Fieldsize option)

 

[boblarson]

Nah, that's okay George. It is good to get the correct wording going. So,
yes in the table it uses the word NUMBER for datatype (even though that isn't
actually accurate based on the definition of datatype in the help file, and
even in other places) and FIELD SIZE is really the datatype of Single,
Double, Decimal, Integer, Long Integer, etc.

For example - this is a direct quote from the Access help file:

"Decide what kind of data type (data type: The characteristic of a field
that determines what type of data it can hold. Data types include Boolean,
Integer, Long, Currency, Single, Double, Date, String, and Variant
(default).) to use for a field based on these considerations:"


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.