Multy function field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have a field that is strickly a number field which I can
calulate totals, but is their away to have text in it on one day and number
in it on others . As an example I might enter "SL" for sick leave and then
the followind day have a number in it. I would like calulate those field that
which have numbers in it. If not please help me with an alternate plan. I am
restricted in my view of the report.

thanks in advance.
 
Nick

It's not good database design to have a field hold more than one type of
data. Why not have one field for type and another for the related number?

If you must, you could convert the data type to Text (this type will hold
both characters and digits). It would be up to you to come up with the
procedures that parsed this into either numbers or text ... wouldn't it be
easier to have two separate fields?!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top