Thanks Duane,
The query will be used to provide an on line form for members to
register for the "Next" meeting. The Secretary having entered the
name of the meeting in "tNextMeeting".
As a result I need the field for the "MeetingID" to be filled by default.
Many thanks,
Robin Chapple
At 22/04/2012 02:00 PM, you wrote:
>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
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
Tidak ada komentar:
Posting Komentar