By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,408 Members | 1,914 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,408 IT Pros & Developers. It's quick & easy.

Field type with greater than, less than signs

P: n/a
Hello all,

First, I am grateful for this forum and all comments that will be
posted.

I am designing a database that compiles data from sewage treatment
plants. Mostly the data is numeric. Mostly...

There are 4 or 5 different fields where the data will read as <10 or
950. When I leave these fields as text, then I am faced with still

compiling these results as if they were words, and so reporting on
them is difficult. If this is the only option I have then I will
continue on this vein.

I was wondering if anyone has been in this situation and come up with
a way of having three columns: one for the number, another for the
greeater or lesser symbol (chosen by the user if needed) and a third
column to mark the relationship. And then integrating this into the
set-up of the database.

mathematically if something is less than 10, it could be 9.9, or 5, or
3 or .2, so... converting these to a number may not provide an
accurate solution. My greatest challenge, is I am mainly compiling
numbers and then I'm faced with 4 or 5 field of numbers that aren't
really numbers, words really, and still wanting to pull performance
summaries.

I can list them instead... Any comments or ideas are welcome.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Having been a laboratory manager in a refinery and having implemented a complex
laboratory information management system, I can speak on this ---

You need to design the reporting of test results so that test results fall into
types: numeric, <XX, >XX, Yes/No, Text. In your 4 or 5 fields, assuming that
all are either <XX or >XX, some must be specified to be always reported as <XX
and the others always reported as >XX. When you record the test results, you
then only record the number part and not the LT or GT sign. This gives you the
ability to query the test results table. On forms, you include the LT or GT
signs in the label for the fields. For reports, you use the Format function to
display results with the LT or GT sign much like how you display the parantheses
and dash of a telephone number.

BTW, I develop integrated Palm Pilot/Access Database systems that fit well where
samples are collected and testing is performed. A user interface is created on
the Palm and data is entered into the Palm. This makes possible recording the
data at the point the data is generated. At some later point, the data in the
Palm is downloaded to the database. The database then can perform any database
functions on the data and can report on the data. If you are interested, contact
me at the email below.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"trinity" <tr**********@lycos.com> wrote in message
news:f3**************************@posting.google.c om...
Hello all,

First, I am grateful for this forum and all comments that will be
posted.

I am designing a database that compiles data from sewage treatment
plants. Mostly the data is numeric. Mostly...

There are 4 or 5 different fields where the data will read as <10 or
950. When I leave these fields as text, then I am faced with still

compiling these results as if they were words, and so reporting on
them is difficult. If this is the only option I have then I will
continue on this vein.

I was wondering if anyone has been in this situation and come up with
a way of having three columns: one for the number, another for the
greeater or lesser symbol (chosen by the user if needed) and a third
column to mark the relationship. And then integrating this into the
set-up of the database.

mathematically if something is less than 10, it could be 9.9, or 5, or
3 or .2, so... converting these to a number may not provide an
accurate solution. My greatest challenge, is I am mainly compiling
numbers and then I'm faced with 4 or 5 field of numbers that aren't
really numbers, words really, and still wanting to pull performance
summaries.

I can list them instead... Any comments or ideas are welcome.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.