I have a query that works in the Access database engine, however when I execute it as part of my ASP page, it only returns the FIRST location joined with each program_update.
SELECT Program_Updates.ProgramID, Program_Updates.Name,
Location.StartDate, Location.EndDate, Location.LocationName...