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