Solved Which numeric format to use?

[Gasman]

Hi all,
I discovered a problem with my Diabetes DB.
I use a factor to multiply by the set value per 100g,100ml or Each.

However whan the value is small like 0.1g per 100g, I am getting zero.
I initially had the number as Single and 2 dec places.
I then tried Currency, but I do not want the £ showing.
Currently I am on Double, but if I enter 0.1 into the table, it just changes it to 0?

So what numeric format should I be using please?

Now changed to

 

[cheekybuddha]

Use Currency.

You can remove the pound sign in the format (in the table options)

 

[Gasman]

That appears to have fixed it.

Thank you David.

 

[cheekybuddha]

 

[gemma-the-husky]

Using double (or single) shouldn't change 0.1 to zero..

 

[Gasman]

Not a biggy, but when I run a query that shows Factor * Carb/Sugar/Fibre I still get the £ sign, but not in my form?
I changed the numerics to Currency, format as Fixed and decimal places as 2.

 

[cheekybuddha]

Not a biggy, but when I run a query that shows Factor * Carb/Sugar/Fibre I still get the £ sign

 

[cheekybuddha]

I changed the numerics to Currency, format as Fixed and decimal places as 2

Doh! Finish reading the whole thing, Dave!

IIRC, you have to do it in the query designer too.

 

[cheekybuddha]

 

[Gasman]

Wow!, I have never ever set a format in a query.

Thank you David, learning something new all the time.

I had to Google to see how it was done.

 

[cheekybuddha]

Wow!, I have never ever set a format in a query.

IMHO, it's pretty irrelevant because one would never normally display a query in the query designer in any normal usage

 

[Gasman]

True, but handy to know anyway.
This is just for my personal use, so not making it bullet proof or even pretty, just functional.

 

[The_Doc_Man]

Speaking of using a calculator, it is important to know what KIND of calculator you are comparing against, since some of them are binary but some are BCD and thus round off differently for fractions. Can't remember exact model numbers, but back in my college days, some HP hand-held calculators were BCD internally. The one on your modern cell phone probably IS binary so would have similar rounding as your 'puter.