I am creating a query that retrieves data from one table and creates a
second table. I want to name the columns in the new table using the
contents of the controls from a form within the same mdb. The form will
be open when this query is run, but I am having trouble creating and
saving the query.
Here is a sample of what I am trying to do...Any help is greatly
appreciated!!
Thanks
SELECT IndividualHolidays.SU, IndividualHolidays.SSN,
IndividualHolidays.Init, IndividualHolidays.LName,
Max(IndividualHolidays.NewYearsDay) AS
Forms!HolidayDatesEntry!NewYearsDay,
Max(IndividualHolidays.AftNewYears) AS
Forms!HolidayDatesEntry!AftNewYears,
Max(IndividualHolidays.PresDay) AS Forms!HolidayDatesEntry!PresDay,
Max(IndividualHolidays.AftPresDay) AS
Forms!HolidayDatesEntry!AftPresDay
…<etc
INTO HolidaysByEmp
FROM IndividualHolidays
GROUP BY IndividualHolidays.SU, IndividualHolidays.SSN,
IndividualHolidays.Init, IndividualHolidays.LName;
--
AaronC
------------------------------------------------------------------------
AaronC's Profile:
http://www.excelforum.com/member.php...o&userid=21240
View this thread:
http://www.excelforum.com/showthread...hreadid=387226