Baffled by the field format 'Single' in table design 1

[Cosette]

Hi all,

I don't understand why this is happening but it is. I have values that measure weight in metric, i.e. [blue]xxxx.xx[/blue] As such I have defined that field property as a Single with 2 fixed decimals.

When I sum that field in queries, I get eight decimals, duh!!!

The help mentions that single and double use floating point calc, but that shouldn't interfer on summing up data defined with two decimals only, right?

What am I missing?

Thanks

David

 

[krymzon]

i'm pretty new with access myself but i think there is a logical answer to your problem. working with alot of products from microsoft and compainies similar i know there are a few querky things that you have to deal with every once in awhile. so i'm going to guess that in this case eventhough your fields are defined to two decimal places, it wont mean that the sum will come out as two decimal places. you would think it would, but its obviously not here...lol. might be a glitch in the query code maker in access itself or just some renagade code thats causing this problem. dont worry about it to much because you can just mask it in a report or even in the query itself i'm sure. just as long as the numbers are right, which they should be i'm sure its just a small glitch or maybe even a user error that you overlooked

<i>there are 10 people in this world. those who know binary, and those who don't.</i>

 

[traingamer]

You can always use field type decimal with the appropriate decimal places.

traingamer

 

[dhookom]

David,
When you set properties like "Single with 2 fixed decimals" you are setting the display of the values in the field. You are not affecting the value stored in the field. For instance, you could have a date field with the format set to"
Format: mmmm, yyyy
so it would display February, 2005
The actual value stored would also always contain the day of the month.

Don't get confused by display formats and actual stored values.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]