non-numeric value in a numeric field

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: aa (aa_at_virgin.net)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 20:57:06 +0100

I have a table of chemicals' properties. The fields contain numeric data. But there are some substances for which some property has a non-numeric value. Like, say, Flash Point some liquids have a numeric values for it, whereas others have it equal to "None".

How do people get round this?

One of the solution> I thought, would be entering a certain number, which I know for sure, would never be equila to Flash Point of any substance, and then add some logic when making queries. But this looks very awkward. Any other approaches?

Relevant Pages

  • Fastcode IsPrime B&V 0.1
    ... Released in the attachments group. ... This years competition is entering the final round and I will try to make ...
    (borland.public.delphi.language.basm)
  • Re: OT-ish brainteaser
    ... >>carry on entering for the same round? ... > Caption Competition: http://sig.comps.org/caption/ ... Prev by Date: ...
    (uk.rec.competitions)
  • Daves non-art contest - win nothing at all
    ... Sherm is excluded from ... entering, since he is likely to want to come round and hit me over the head ...
    (rec.music.makers.guitar.acoustic)
  • Re: And thats why hes Tiger
    ... Except that Tiger is not always ahead entering the fourth round of a ... -- he's had a plethora of chances to come from behind on Sunday ...
    (rec.sport.football.college)
  • How do I use Roundup in a logical test in excel
    ... I am entering a formula using a logical test in Excel. ... always round up to the next whole number. ...
    (microsoft.public.excel.worksheet.functions)