What is best way to filter through multiple fields to get an answe

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the best way to filter through multiple fields to get an answer for
another field?
i.e. I have 10 seperate fields I want to filter through. Each field will
have text or not. If it does have text, I want to put a comment in a new
field, if it does not have text, it will go to the next field and test it.
I was trying to do this with 'if', but didn't get very far with it.
any help appreciated.
 
What is the best way to filter through multiple fields to get an answer for
another field?
i.e. I have 10 seperate fields I want to filter through. Each field will
have text or not. If it does have text, I want to put a comment in a new
field, if it does not have text, it will go to the next field and test it.
I was trying to do this with 'if', but didn't get very far with it.
any help appreciated.
Click to expand...

What's the structure of your table, JD? It sounds like it's not
properly normalized. If you have a one (item) to many (up to ten
comments), then you should have TWO TABLES, in a one to many
relationship. Rather than ten comment fields, you would add ten
*RECORDS* to this related table, one for each comment, using a
Subform.

If I'm misunderstanding the structure please post back.

John W. Vinson[MVP]
 
Hi John, thanks for the reply.
I've been out of the loop for simple dbase management, but I remember the
basic ideas behind 'if' and 'ifelse'. But I can't seem to figure out the
right mix for this problem! I'll try to clarify.
I have one table that suits my needs.
Lots of stuff in there. Name, address, etc.etc.
There are lets say 10 seperate fields in there, we'll call them field-1
through field-10.
They are simple text fields.
I want to check each field, in order, for the occurance of any text.
If there is text in a field I want to put the value "Beg","Int","Adv" in a
new field.
If there is not text in a field, search the next field.
Does this make any sense?
Any advice helps,
 
Hi John, thanks for the reply.
I've been out of the loop for simple dbase management, but I remember the
basic ideas behind 'if' and 'ifelse'. But I can't seem to figure out the
right mix for this problem! I'll try to clarify.
I have one table that suits my needs.
Lots of stuff in there. Name, address, etc.etc.
There are lets say 10 seperate fields in there, we'll call them field-1
through field-10.
They are simple text fields.
I want to check each field, in order, for the occurance of any text.
If there is text in a field I want to put the value "Beg","Int","Adv" in a
new field.
If there is not text in a field, search the next field.
Does this make any sense?
Any advice helps,
 
Hi John, thanks for the reply.
I've been out of the loop for simple dbase management, but I remember the
basic ideas behind 'if' and 'ifelse'. But I can't seem to figure out the
right mix for this problem! I'll try to clarify.
I have one table that suits my needs.
Lots of stuff in there. Name, address, etc.etc.
There are lets say 10 seperate fields in there, we'll call them field-1
through field-10.
They are simple text fields.
I want to check each field, in order, for the occurance of any text.
If there is text in a field I want to put the value "Beg","Int","Adv" in a
new field.
If there is not text in a field, search the next field.
Does this make any sense?
Any advice helps,
Click to expand...

No, it really doesn't, not to me. You're searching ten fields
containing different types of data? Are you searching for a particular
(variable) text string, or just looking for any record where any one
of these fields is not NULL? What's the significance of the Beg, Int,
Adv and how do you choose which one to put? What do you want to do if
there is text in TWO of the fields... or three?

John W. Vinson[MVP]
 
Back
Top