does this help at all

http://www.sqlservercentral.com/Forums/FindPost1774146.aspx

just curious....how many rows/columns in the Access table?

not sure what the OP wants....keeps peeping out from behind the sofa each day and logs on......but never replies 🙂

ok...so thats the output....what was the "input" for this result....(you have said that it is datetime datatype)

have you got an example of a datetime that is creating this problem?

here is the original post set up for SQL

USE tempdb

GO

IF OBJECT_ID('tempdb..TABLE1','U') IS NOT NULL

DROP TABLE TABLE1;

IF OBJECT_ID('tempdb..TABLE2','U') IS NOT NULL

DROP TABLE TABLE2;

CREATE TABLE Table1(

callID_T1 ...

Jeff Moden (4/11/2016)

---

J Livingston SQL (4/11/2016)

---

It would be appreciated if the OP can post some sample data etc.

if there are millions of rows as suggested then it would be good...

It would be appreciated if the OP can post some sample data etc.

if there are millions of rows as suggested then it would be good to see some performance testing.

no idea really, because you haven't given us your expected results based on...

i'll throw this out here

make of it what you will and see how you get on.....no claims on performance or accuracy, need you to review to see if it what...

can you please post create table / insert data scripts and expected results based on your sample data

https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

well...I am no Access expert, but I am guessing that Access is pulling all 6 million rows into your access app in the first instance.

GrassHopper (4/8/2016)

---

I have a sql table with about 10 columns. I link the table to an ms access application. When I open the table in ms access and...

not sure if this is what you want....tis always good to detail expected results, saves time and confusion

SELECT CASE WHEN ColumnaName = 'CustomerGroup' THEN...

is there any primary key or a unique index on your SQL table?