Well, no one has responded yet, and, admitedly, I can't say why you are getting your errors, but I would suggest trying to use a format file. You can...

pwatson, the below is one example of how to post readily consumable code, so we can simply cut and paste into QA. This is just a general example of...

I might be over simplifying this, but why can't you do

SELECT

Col1,Col2,Col3,Col4

FROM YourTable

?

iapearsall, I'm not really sure what you are asking. Do you think you have an Access problem or a SQL Server trigger problem? Without full table definitions...

Ken, if you have to use datasheet view, you may have to leave it locked, in a subform, then on a different form, possibly a popup, have some unbound text...

Are you trying to update the records directly from an Access form or grid? Typically what I do is have some unbound text boxes on a form, then with...

You could try this, which would eliminate the CASE. There are probably some instances that would break it, but for cases where there is never a space in the...

Karthik, how is the country choice passed to your database? String? What does it look like?

Brent, I have to agree with Allen. Unless there is data in the Access database you are using in your crosstabs, you would probably be best served doing as...

Gent

This is a 2000 forum, but this...

SELECT DATEPART(qq,GETDATE())

will give you the quarter.

Greg Snidow (6/1/2009)

I think he's using SQL 2000?

I'm not sure if I'm over simplifying this, but is this what you...

I think he's using SQL 2000?

I'm not sure if I'm over simplifying this, but is this what you are looking...

Aha...that makes much sense now. Thanks for the input.

Look in BOL for 'linked servers' or 'OPENROWSET'.

Daryl

I'm not getting the same results as you are getting. Check out my code below, just to make sure I have captured your process correctly. Please note how...