Robin,
What are you wanting to do with the results of the query? I expect you need to remove the JOIN if you want to return any records.
Duane Hookom
MS Access MVP
--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple <robinski@...> wrote:
>
>
> Using Access 2007 with Windows7.
>
> I have a registration table for meetings and a separate table for the
> secretary to determine the "Next Meeting" it has only one record.
>
> I need "tNextMeeting" table to use the field "MeetingID" from the
> "tNextMeeting" table. This SQL does not work.
>
> SELECT tNextMeeting.MeetingID, tRegistrants.ClubID,
> tRegistrants.MemberID, tRegistrants.ChoiceID,
> tRegistrants.RegistrantID, tRegistrants.PostHolderID, tRegistrants.LastUpdated
> FROM tRegistrants INNER JOIN tNextMeeting ON tRegistrants.MeetingID =
> tNextMeeting.MeetingID
> ORDER BY tRegistrants.ClubID;
>
> I have also tried to make the default value of "MeetingID" in the
> "tRegistrants" table as [tNextMeeting].[MeetingID] which shows the
> error message could not find the field 'tNextMeeting].[MeetingID'
>
> Is my plan possible?
>
> Many thanks,
>
> Robin Chapple
>
Tidak ada komentar:
Posting Komentar