Hi,

I am trying to use make table query to export data from two tables , but i want to define the name for the new table . itried using parameter and it didnt work out. the query is mentioned below. pls help and correct any mistakes in syntax if there.

PARAMETERS [Name] Text ( 255 );
SELECT [Employees Master].EmployeeNumber, [Employees Master].Designation, [Employees Master].PFNumber, [Employees Master].Title, ([Employees Master].[FirstName]+[Employees Master].[MiddleName]+[Employees Master].[LastName]) AS EMPName, [Employees Master].OfficeLocation, [Employees Master].Salary, [Employees Master].Basic, [Employees Master].HRA, [Employees Master].Conveyance, [Employees Master].Medical, [Employees Master].LTA, [Employees Master].OT, [Employees Master].Gratuity, [Employees Master].OtherAllowance, [Employees Master].Arrears, [Employees Master].LoanDeductions, [Employees Master].OtherDeductions, ([Employees Master].LeaveMedical + [Employees Master].LeaveCasual + [Employees Master].Leaveprevilige+[Leave Master].PLOpeningBalance+ [Leave Master].SLOpeningBalance+ [Leave Master].CLOpeningBalance) AS [Total Leave], ([Leave Master].PLAvailedApril+ [Leave Master].CLAvailedApril+ [Leave Master].SLAvailedApril+ [Leave Master].PLAvailedMay+ [Leave Master].CLAvailedMay+ [Leave Master].SLAvailedMAy+ [Leave Master].PLAvailedJune+ [Leave Master].CLAvailedJune+ [Leave Master].SLAvailedJune+ [Leave Master].PLAvailedJuly+ [Leave Master].CLAvailedJuly+ [Leave Master].SLAvailedJuly+ [Leave Master].PLAvailedAugust+ [Leave Master].CLAvailedAugust+ [Leave Master].SLAvailedAugust+ [Leave Master].PLAvailedSEP+ [Leave Master].CLAvailedSEP+ [Leave Master].SLAvailedSEP+ [Leave Master].PLAvailedOCT+ [Leave Master].CLAvailedOCT+ [Leave Master].SLAvailedOCT+ [Leave Master].PLAvailedNOV+ [Leave Master].CLAvailedNOV+ [Leave Master].SLAvailedNOV+ [Leave Master].PLAvailedDEC+ [Leave Master].CLAvailedDEC+ [Leave Master].SLAvailedDEC+ [Leave Master].PLAvailedJAN+ [Leave Master].CLAvailedJAN+ [Leave Master].SLAvailedJAN+ [Leave Master].PLAvailedFEB+ [Leave Master].CLAvailedFEB+ [Leave Master].SLAvailedFEB+ [Leave Master].PLAvailedMAR+ [Leave Master].CLAvailedMAR+ [Leave Master].SLAvailedMAR) AS [Availed Leave] INTO [Name]
FROM [Leave Master] INNER JOIN ([Employees Master] INNER JOIN [Wage Master] ON [Employees Master].Designation = [Wage Master].Designation) ON [Leave Master].EmployeeNumber = [Employees Master].EmployeeNumber;


thanks in anticipation and consideration.

vijay