HELP! Please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FJinSA - 26 May 2006 19:51 GMT

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];

Reply to this Message

Jerry Whittle - 26 May 2006 20:32 GMT

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.

Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I am trying to run this append query and it is not working....anyone see
> anything wrong?
[quoted text clipped - 10 lines]
> 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];

Reply to this Message