HELP! Please

[FJinSA]

I am trying to run this append query and it is not working....anyone see
anything wrong?

INSERT INTO [Audit Table] ( OM, CSM, TB, UID, Start_Date, Login, Logout,
[Sch Start], [Sch Stop], [TCS Code], [HR Code] )
SELECT HR.WM_MGR_NAME_L8, [Sch Qry].CSM, [Sch Qry].TB, [Sch Qry].UID, [Sch
Qry].START_DATE, Format(LLO!Login,"Short Time") AS Login,
Format(LLO!Logout,"Short Time") AS Logout, [Sch Qry].[S Start], [Sch Qry].[S
Stop], [TCS Conv].[TCS Conv] AS [TCS Code], [Code Conv].Conv AS [HR Code]
FROM (([Sch Qry] INNER JOIN (HR INNER JOIN [Code Conv] ON HR.[HR TYPE] =
[Code Conv].[HR Code]) ON ([Sch Qry].UID = HR.UID) AND ([Sch Qry].START_DATE
= HR.Date)) INNER JOIN LLO ON ([Sch Qry].UID = LLO.UID) AND ([Sch
Qry].START_DATE = LLO.Date) AND (HR.UID = LLO.UID) AND (HR.Date = LLO.Date))
INNER JOIN [TCS Conv] ON [Sch Qry].[Seg Code] = [TCS Conv].[TCS Code];

 

[Jerry Whittle]

What do you mean by "not working"? Error messages? Wrong records being
appended? No records being appended?

If an error message, tell us what it is.

In no or wrong records, run just the select statement an see what happens.

One thing that I did see what the word "Date" being used as a field name. As
there is a Date() function, Access could be getting confused.