query 2 table with only 1 value of each table

[haerion]

Hi all,

I'm trying to do a weird query here, I have 2 table, on containing a Student ID from high scool with is name and the day he is gonna be free to visit, which is only one day per person,table look like NoES, Lastname, Firstname and Day. On the other table, I have a Student ID from a College student, table look like NoER, Lastname, Firstname, Day, Hour. If the same person can be free more than one day, there will be a number of line equal the number of day he can be there for a week.I want to match on the same day, all the high school student with a different College Student, there will be more college student than high school one. Right now Im getting for each name, all the College free on the day I chose.

Any help will be helpful

Thanks in advance

Regards,

Haerion

 

[straybullet]

In Design view, create a relationship between the tables on the Day field.
This will cause only those which match to be returned.

Let them hate - so long as they fear... Lucius Accius

 

[haerion]

Hi stray

I already did the relationship between the day field, but the problem is that if there is 5 college student that have monday, I dont want them to appear 5 time for one HS student, and when the college student is matched with the HS one, I dont want his name to appear to other student, I want one different for each HS student.

Thanks

 

[straybullet]

sorry - misunderstood... I'll be thinking about this one. Im sure there are others here who are already doing the same.

Let them hate - so long as they fear... Lucius Accius

 

[haerion]

Anyone have an idea about this one, it is pretty hard to figure out