URGENT: non-numeric values in "number" fields

[Guest]

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

 

[strive4peace]

"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. "

you can't have it both ways... numbers and text unless your numbers are
stored as text (okay if that is what you need and you won;t do numeric
calculations)

if stored as numbers, what you can do is format zeros to show "N/A",
but what if the value really IS zero?

nulls will show up as empty spaces (which I like because they are easier
to spot)

You have 4 choices on number format:

1. positive numbers
2. negative numbers
3. zeros
4. nulls


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[John Vinson]

Blanks - given their ambiguity - I very much
hope to avoid.

As Crystal says, you can't get away from using either NULL or numbers.
What is the sum of 3, 4, 6 and N/A?

What you *can* do is use a Format wherever the value needs to be
displayed:

#;-#;#;"N/A"

to display positive numbers as is, negative numbers preceded by a
minus sign, 0 as 0, and NULL as the text string N/A.

John W. Vinson[MVP]

 

[Guest]

Thanks strive4peace, very helpful. . . . .

best
marika

 

[Guest]

Oh wow - thank you!!

very helpful. . . . .

As Crystal says, you can't get away from using either NULL or numbers.
What is the sum of 3, 4, 6 and N/A?

What you *can* do is use a Format wherever the value needs to be
displayed:

#;-#;#;"N/A"

to display positive numbers as is, negative numbers preceded by a
minus sign, 0 as 0, and NULL as the text string N/A.

John W. Vinson[MVP]

 

[strive4peace]

you're welcome, Marika happy to help


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[Joseph Meehan]

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

I would suggest adding an additional field. In that field you could
identify when and/or what you want to display other than numbers. For
example it might be a binary field where yes would mean you want to display
NA.

Then on your forms and reports you could chose to display the contents
of the number field or the letters NA depending on the contents of that
binary field.