decimal point problem

[David B]

I have a app that handles our milk business.

The units are recorded as full numbers in the sales table.
We have started to handle eggs which are sold by the dozen and sometimes a
customer wants 3.5 dozen.

I want the milk numbers to continue to display without a decimal point but
where half doz are involved display as 3.5

Hope that makes sense
TIA
David B

[Allen Browne]

In table design, this Quantity field will be data type Number. In the lower
pane, the Field Size should be Double so it accepts fractional values. Make
sure there is nothing in the Format property. It should then work as
requested.

If you have a form, you may have to clear the Format property of the text
box also.

(Setting the Format to General Number should have the same result too.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David B" <da***@marleycote.fsnet.co.ukwrote in message
news:Ot******************************@bt.com...

>I have a app that handles our milk business.

The units are recorded as full numbers in the sales table.
We have started to handle eggs which are sold by the dozen and sometimes a
customer wants 3.5 dozen.

I want the milk numbers to continue to display without a decimal point but
where half doz are involved display as 3.5

Hope that makes sense
TIA
David B

[David B]

Many thanks for the prompt reply
David B

"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:44***********************@per-qv1-newsreader-01.iinet.net.au...

In table design, this Quantity field will be data type Number. In the
lower pane, the Field Size should be Double so it accepts fractional
values. Make sure there is nothing in the Format property. It should then
work as requested.

If you have a form, you may have to clear the Format property of the text
box also.

(Setting the Format to General Number should have the same result too.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David B" <da***@marleycote.fsnet.co.ukwrote in message
news:Ot******************************@bt.com...

>>I have a app that handles our milk business.

The units are recorded as full numbers in the sales table.
We have started to handle eggs which are sold by the dozen and sometimes
a
customer wants 3.5 dozen.

I want the milk numbers to continue to display without a decimal point
but
where half doz are involved display as 3.5

Hope that makes sense
TIA
David B