Thank you so very much, I also imagine that performance will suffer some and I will try to work on that. Luckily this wont be run often, more of a...

Thanks for that article, it looks like a very valuable tool. I'm going to try to do the hands on approach with it as it does seem to be pointing...

Thanks so much SQlraider for your reply. One of my friends actual helped me on this and it was something simple I was just having a brain fart. Here is...

Nevermind, I figured it out. Forgot some Parntheses..:blush:

Thanks, now there is coffee all over my screen:laugh:

So I figured this on out. I ended up using three CTE's. I also started with the Max(Date) first on advise from a friend then went from there.

Here is...

Thank you so much for your reply. I have been hearing so much about CTE's that I thought I would try to make one. What you are saying definitely makes...

Thank You so much, the first one in had worked great.

I would really like to understand why it worked. Do you know of any links or videos on when...

Never mind it works! was able to import into Map wizard with accurate counts.

CREATE TABLE #TempLocation

(Code Varchar(5) PRIMARY KEY

,Location Varchar(10))

INSERT INTO #TempLocation

VAlUES ('OR001', '87120')

------------------------------------

87120ArtStreet241542OR0012013-06-11 00:00:00.000No Insurance

87120ArtStreet243318OR0012013-07-02 00:00:00.000No Insurance

87120ArtStreet243321OR0012013-07-02 00:00:00.000No...

Thanks Mickey this is the second time you have helped me and I very much appreciate it. I still very new with SQL and trying my best to learn it...

Yes, I think this is what I am concluding could I still do this with just a temp table? Sorry if the question sounds dumb still very new.

But how would i do that in SQl? I figured I would need to have some sort of statment saying that when code OR001 is returned it equals a...

Thanks for the responses, I am currently looking at using the web form in Access and testing that, I was also looking at using a form plug-in in a WordPress...

You guys are great thanks for all the help! I am one of those weirdo's that even though I have been only writing sql statements for a couple of months...

Micky you are one awsome dude! Worked like a charm:w00t: I had to get this list the old fashion way by hand comparing lists in excel and then do...