what type of fields can I use < & > in?

[Michael]

I need to ues the < & > signs in my data base as I am enterint analitical lab
results, when I do i get an error message. how can i correct this problem? I
have used both text& number formatt , stil get this message.

 

[Joan Wild]

I need to ues the < & > signs in my data base as I am enterint
analitical lab results, when I do i get an error message. how can i
correct this problem? I have used both text& number formatt , stil
get this message.

I don't have this problem. What is the text of the error message?

 

[TC]

It's a /bad idea/ to enter values like that. You will have tons of
problems using them "down the track". A better solution would be to
have three seperate numeric fields, for each reading: a "less than"
field, an "equal to" field, and a "greater than" field. Then you just
enter the reading, into the appropriate field. This will make it easier
to use those values "down the track".

For example:

R < 15:

R_lss_than: 15
R_equal_to:
R_gtr_than:

R = 15:

R_lss_than:
R_equal_to: 15
R_gtr_than:

R > 15:

R_lss_than:
R_equal_to:
R_gtr_than: 15

PS. This is not the right newsgroup for asking such questions. Look for
one in the microsoft.public.access heirarchy devoted to "database
design", or similar.

HTH,
TC