Get data that I want problem?

  • Thread starter Thread starter JPP
  • Start date Start date
J

JPP

I have three tables - tblRoster, tblMeetingDates and tbl Year . The roster
table has all the names, address, city... The meeting tables has when and
where each students meeting will be held (one a year). The roster table has
a 'year' field that holds the current school year (2005-06). The meeting
table also has a year field- hold the information for that particular year
as to when the meeting was or will be help. TblYear holds one field
2005-06, 2006-07....

I have a query set up that populated a form, but if there is no meeting
scheduled yet for the upcoming year, no data is presented. I would still
like at least the name and the year sent to the report for printing.

Thanks in advance.
Joe
 
Dear JPP:

I expect what you probably need would be a cross-product of the Roster and
Year tables, with a left join to the MeetingDates.

SELECT *
FROM tblRoster, tblYear
LEFT JOIN tblMeetingDates
ON tblMeetingDates.MYear = tblYear.MYear

This is a very rough starting place, not knowing the names of your columns
or how tables join.

Tom Ellison
 
TblRoster has StudentID, LastName, FirstName, Year (the present school
Year updated now to next school year) .....
TblMeetingDate has StudentID, MeetingDate, MeetingTime, MeetingLocation,
Year(for what year this meeting will cover)...
tblYear- Year (2005-06, 2006-07...)

Not sure how to join these (studentID??) so that I get what I need.
JPP
 
Back
Top