INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Query Help

Query Help

(OP)
I know a little about querries but not complicated ones.

I have 2 tables

table1
masterid1
classes <-- This is a string field with comma seperated values


tblclasses
masterID2
field1
field2 <-- This is a string field that has comma seperated values
a bunch of of other fields that are irrelevant

So what I am trying to do is have a query to gather all the field2 values from tblclasses for each masterID in Field 1.

Example

Table1. (1 row of data)
Masterid1 = 1000
classes = Math, PE, Science, English,

tblclasses (1 row of data)
field1 = math
field2 = algebra, geometry, calculus, statistics

next row
field 1 = English
field 2 = american lit, british lit, grammer, essay


The query or code will generate something to the effect of

Where masterid1= 1000
str = algebra, geometry, calculus, statistics, american lit, british lit, grammer, essay

Any ideas?


I am using vb2008 to connect to a access database where the tables are located.

Thanks a lot

Chris

RE: Query Help

Does Master ID1 mean the same thing as Master ID2?

Beir bua agus beannacht!

RE: Query Help

Is there any way you could correct your table structures to be normalized? Where is Master ID2?

Also consider using TGML to format your posts so they are more readable:

Table1. (1 row of data)
Masterid1    classes
1000         Math, PE, Science, English, 

tblclasses
field1       field2
math         algebra, geometry, calculus, statistics
English      american lit, british lit, grammer, essay
 

Duane
Hook'D on Access
MS Access MVP

RE: Query Help

(OP)
Thanks for the responses. I know how to use the code buttons but will look at how to use the Tgml for tables.

MasterID1 and MasterID2 are autonumber for each table.

RE: Query Help

I used the Pre TGML tag to format the table. If masterID1 and 2 are both autonumbers, I can't see how they can stay in synch unless they are not related.

Duane
Hook'D on Access
MS Access MVP

RE: Query Help

(OP)
Duane,

I do not understand your response.


I want to return all field2 values in table2, if field1 in table2 is contained in the classes field of table1.
The classes field is a comma separated values field


The autonumbers are irrelevant, except using for a where statement


Chris

RE: Query Help

Do you have a table of all unique classes? Or are you considering normalizing your tables like suggested?

Duane
Hook'D on Access
MS Access MVP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close