Robin-
If you want the "next" meeting to show up in a combo box for MeetingID, use a
UNION query that pulls the MeetingID from your Meetings table and the MeetingID
from tNextMeeting as the Row Source.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Villefranche-sur-mer, France)
------------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
Sent: Sunday, April 22, 2012 6:01 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Fixing a default value for a table.
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