need to select one field based on item in another field

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

Guest

I have a table that has fields T1 to T10 corresponting to fields DEC1 to
DEC10 and I would like to search the fields in DEC1 to DEC10 , based on a
criteria and select the corresponding T1 to T10 and report the results. For
example; if I am looking for a case sensitive value (say the letters BR)
anywhere within the fields DEC1 to DEC10 and find it in DEC4 I would then
like to be able to select the corresponding value in T4 and report it
together with other fields. Can anyone please help me with this? Greatly
appreciated.
Romin
 
Your Tables sound like spreadsheets which probably not conforming to the
Relational Database Design Principles. For example, you have repeating
(groups of) Columns which is a "no-no" in RDDT. In addition, T1 to T10 and
DEC1 to DEC10 indicate that you store values in the Field names also (and
Access / JET cannot access values embedded in names). This is why you have
to find the Column that has a value and then retrieve the value in a
corresponding Column.

Suggest you back track and redesign your Table Structure so that it
conformsto the RDDP ...
 
Van
I don't think I described my data base properly but maybe this explanation
would be better. And thanks for the quick The fields T1 to T10 contain
values (ie depths) and DEC1 to DEC10 contain data. So I want to select based
 
Van
I don't think I described my data base properly but maybe this explanation
would be better. And thanks for the quick The fields T1 to T10 contain
values (ie depths) and DEC1 to DEC10 contain data. So I want to select based
 
Van
I don't think I described my data base properly but maybe this explanation
would be better. And thanks for the quick The fields T1 to T10 contain
values (ie depths) and DEC1 to DEC10 contain data. So I want to select based
 
Yes, you still have repeating groups of Fields and you still have T1 to T10,
each of the number after "T" signifies a correspondence with another column
in the range of DEC.

In fact, what you described actually confirms that your Table doesn't follow
the RDDP. Since RDDT books / Web articles can explain in a lot more details
(certainly more than I can type), I suggest you check them out.

Try also as the first step (very basic RDD steps)

http://support.microsoft.com/kb/283698
 
Back
Top