GSquared

thanks, one more question what does the CTE represent?

I just want to keep only unique Load Numbers.

current rows (duplicates)

Load number Event Code Event Desc

123456 ...

Here's the query

SELECT [Load Id],

[Shipment Id],

[End Date],

...

The goal for the end state after the conversion is complete is to have an access front end and a SQL Server backend. It has been extremely frustrating with...

Thank you so much this is a major problem I'm running into while trying to convert queries from access 07 to sql server 05

thanks

😀

It was the same sample earlier that I replaced the IIf with CASE WHEN, I worked through the = problem and now I'm just trying to correct this error...

I replaced all of the IIf with CASE WHEN, but I'm still getting the error message : Msg 102, Level 15, State 1, Line 95

Incorrect syntax near '='.

I apologize,

I have one additional question on the joins

this query is similar to the last I used your example but I'm still getting an error

before

UPDATE [tblShipments] LEFT OUTER JOIN...

Gsquared you Rock! It works like a charm!

Here's a sample of the code and the error message is beneath it

select T1."OAD1LDID" as "Load Id",

T1."OAD1SHPID" as "Shipment Id",

T1."OAD1ACCCD" as "Acs Code",

SUM(T1."OAD1CHGAMT") as "AP Est Acs Amt",

SUM(T1."OAD1BILAMT") as "AR...

I thought I would be able to link the pass through query just like you can link the table to sql server.

Graham,

I connect in Access 07 to a data warehouse using ODBC.

I have linked tables from access db to SQL Server.

I need to be able to copy or recreate...

I've got a couple of simple queries to run (update, delete, etc...), now I moving forward with creating queries to update tables, delete tables, etc.. Is it possible to...

William,

I typed in the delete statement and got the following:

delete tblrwtest;

(0 row(s) affected)

I can run a similar query in access 07 and clear all records in a table. I...