[MS_AccessPros] Fixing a default value for a table.

 

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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Links 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___