Merge data source not recognized

[MarkB]

I have a merge data source that is an Acess query. It works fine without
computed fields but doesn't work with them. The data source won't even show
up in the select list when I choose the DB.

SQL - computed fields

SELECT Events.[From date], Events.[Thru date], Events.Track,
Events.Direction, Sponsors.Name AS Sponsors_Name, Venues.Name AS Venues_Name,
Venues.[Web addr], Sponsors.[Web addr]
FROM Venues INNER JOIN (Sponsors INNER JOIN Events ON Sponsors.Key =
Events.[Sponsor key]) ON Venues.Key = Events.[Venue key]
WHERE (((Events.[From date])>Now()))
ORDER BY Events.[From date], Venues.Name;

SQL + computed fields

SELECT Events.[From date], Events.[Thru date], Events.Track,
Events.Direction, Sponsors.Name AS Sponsors_Name, Venues.Name AS Venues_Name,
Venues.[Web addr], Sponsors.[Web addr], WeekdayName(Weekday(Events.[From
date]),True) AS [From day], WeekdayName(Weekday(Events.[Thru date]),True) AS
[Thru day]
FROM Venues INNER JOIN (Sponsors INNER JOIN Events ON Sponsors.Key =
Events.[Sponsor key]) ON Venues.Key = Events.[Venue key]
WHERE (((Events.[From date])>Now()))
ORDER BY Events.[From date], Venues.Name;

Any help and/or reason for this behavior would be greatly appreciated.

Mark

 

[Doug Robbins - Word MVP]

In Word, select Options from the Tools menu and then go to the General tab
and check the box against the item "Confirm conversions at open". After
doing that, when you go to attach the data source to the mailmerge main
document, you will be given a number of options for the way in which the
connection should be made. Try each of them until you find one that works.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP