Number field - weight format

[Wayne-I-M]

For a number field - is there a weight format.

I can run an update query
IIf(Not ([tblClients]![Weight] Is Null),[tblClients]![Weight] & "kg")
to add the "kg" but this will only work on a text field.

I would like to have the field still remain a number (to make sorting,
reports, etc, simpler) but with a weight format ??

I could just add the "kg" into a calculated field but ......

Any ideas would be helpful

 

[Wayne-I-M]

Thanks Chris

I was trying to keep away from using a calculated field or just adding "kg"
if not is null.

This is for a ski hire shop (that I am doing a free job for) and they do
over 40,000 hires per season so I am trying to keep the speed up by only
using a few calculations as possible - but when you add in all the prices,
sizes, equipment locations, out for service, etc, etc, etc it is quite
difficult.

Just thought there may be a format I didn't know about - I am trying to
automate thier on-line booking system and British and Americans only use
stones and onces so I wanted to convert this to ISIA standards for the DIN
settings. At the moment they just get an e mail from thier booking web site
and I am just getting to go straight to the DB - which as it's here (in
Italy) is all in KG's

May not be possible ??
--
Wayne
Trentino, Italia.

If it's always going to be kg use a calculated field in your select queries.
If the units are varied add a new text column named units to the table and
add this column to your queries for that table, like this:

select weight, units from tblclients

Chris

For a number field - is there a weight format.

I can run an update query
IIf(Not ([tblClients]![Weight] Is Null),[tblClients]![Weight] & "kg")
to add the "kg" but this will only work on a text field.

I would like to have the field still remain a number (to make sorting,
reports, etc, simpler) but with a weight format ??

I could just add the "kg" into a calculated field but ......

Any ideas would be helpful

 

[Wayne-I-M]

Oh well - another column in the query.
Sort by the original and add calculated next to it.

Always try and cut down on anything thats not really needed, but in this
case can't see any way round it.

Thanks for the tips.

Maybe it will be included in Access 2015