I could bulk insert into a single column and then use the Moden string splitter. If...

I was previously skipping row 1 but now I need to extract some data out of the header.

I'll take a look at script components which I haven't used before.

The file...

Can you move you After Insert trigger logic into the Access 'before insert' event?

If I understand this correctly the trigger needs to run on insert but a record can't be inserted until the trigger runs.

Perhaps you could put your trigger logic in a...

I think the source of your data may be more important (SQL Server) than that where you are querying from. If I am understanding correctly the Access query is interpreted...

SQL server uses % as the wildcard.

See if the last few items in the following article clarifies the situation.

http://www.techrepublic.com/article/10-tips-for-using-wildcard-characters-in-microsoft-access-criteria-expressions/6154704

http://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure/

This looks like a good tutorial.

I would definitely read up on stored procedures. Even if you do not need to use intermediate result sets there are numerous advantages to using stored procedures in reports.

Below is...

In Access we have reports that run/reference mutiple queries in order to excute the final report. My question is how to convert a report that runs mutiple queries over...

Try putting single quotes around the '1' or cast it as VARCHAR-- the expression is trying to compare a string ('ABC') with a numeric (1) and that will generate that...

Oh I see, provide the easy and obvious answer. 🙂

I agree that this is equivalent.

This will work

SomeVal2 = 'ABC' or SomeVal is not null

This won't but...

It works if I drop it in the case statement but I think I need it. Additional sample data below.

I want to exclude XYZ and include ABC replacing its NULL...

I appreciate you spending any time on this at all since it seems like a data issue,

Below is more representative of the situation. Removing the WHERE statement and the query...

>>where column1 = 1

This throws the error Conversion failed when converting the varchar value '-4.67625' to data type int.

>>where IsNumeric(Column1) = 0

This will exclude one row. This is the row...

This works

SELECT

CONVERT(decimal(20,6),Column2)

FROM ....

WHERE column1 <> 'abc'