Thanks Bill,
I have built my UNION query as explained by you:
SELECT tRegistrants.RegistrantID, tRegistrants.ClubID,
tRegistrants.MemberID, tRegistrants.PostHolderID,
tRegistrants.MeetingID, tRegistrants.ChoiceID, tRegistrants.LastUpdated
FROM tRegistrants, tNextMeeting
UNION SELECT Null as RegistrantID, Null as ClubID, null as MemberID,
Null as PostHolderID, tNextMeeting.MeetingID, Null as ChoiceID,
tNextMeeting.LastUpdate
FROM tNextMeeting;
and, because the code generator that I use, I have made a standard
query to lodge on the web based server:
SELECT Meetingz.RegistrantID, Meetingz.ClubID, Meetingz.MemberID,
Meetingz.PostHolderID, Meetingz.MeetingID, Meetingz.ChoiceID,
Meetingz.LastUpdated
FROM Meetingz, tNextMeeting
WHERE (((Meetingz.LastUpdated)>[LastUpdate]-1));
which fails to give me a "RegistrantID" in spite of the fact that the
table "tRegistrants" has "RegistrantID" as an auto number field. As a
result the fails due to the 'null'.
Am I asking too much?
Many thanks,
Robin
At 23/04/2012 02:29 AM, you wrote:
>Robin
>
>You can trick a UNION query by plugging extra fields in the right slots. Say
>tbl1 has 4 fields and tbl2 has 2. The UNION would look like this:
>
>SELECT LastName, FirstName, MeetingDate, MeetingLocation
>
>FROM tbl1
>
>UNION
>
>SELECT Null as LastName, Null as FirstName, MeetingDate, MeetingLocation
>
>FROM tbl1
>
>
>
>
>
>Regards,
>Bill Mosca,
>Founder, MS_Access_Professionals
>That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
>MS Access MVP
> <https://mvp.support.microsoft.com/profile/Bill.Mosca>
>https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
Tidak ada komentar:
Posting Komentar