Urgent! NA values in table with Number Data Type

M

marika1981

Hi!

I have a data table consisting of 10,000 rows with various row headers and
numerical scores, 0 through 10. All the fields containing scores are
formatted as "Number"

Problem is that I'd like, at times, to use the "NA" convention (or some
similar non-numeric convention) in instances when a score was not calculated
or isn't relevant. I'm unable, however to find a way to enter anything but
numeric values in these fields. Blanks - given their ambiguity - I very much
hope to avoid.

Any help would be TRULY APPRECIATED!!!!

Marika :)
 
J

Jeff Boyce

If the data types were "text", you could still store your "numbers" (i.e.,
the digits) and NA.

By the way, do you have multiple fields each storing a different "kind" of
score? If so, your table structure can be greatly simplified. This would
also make Access' features and functions more useful to you.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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

Microsoft Registered Partner
https://partner.microsoft.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

URGENT: non-numeric values in "number" fields 5
Checking for, then listing Null/empty fields in a message box 0
Type Conversion Failure importing number as text 1
how to sum 'n' largest values *not* in an array? 7
How do i bring forward coumn value from record from one table to another Table ? 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Test scoring app w/data entry form,item response table,subtest tot 0
Using text values in Pivot Tables 5

Top