Well the occurrences are all correctly classified now whereas before they weren't so it's probably the way I'm explaining myself that's making things seem wrong.

Howdy guys,

All fixed. Thanks for putting up with me and for more info on how SQL works 😛

I didn't end up using the query, what I did was just...

Thanks for the offer, I think Gila might have me sorted though. I've been staring at these tables and all these numbers and such for so long my brain has...

Ninja's_RGR'us (7/26/2011)

---

Let me compound what and SQL MVP and Microsoft employee just told you.

There's nothing requiring SQL Server to display the rows in any particular order UNLESS you use order...

I'm definitely no expert with SQL Server but that just doesn't seem right . Every time (five times thus far) I do the import (fixing things I've missed and such...

I'm not really sure I follow. :blink:

If I have a table in Access that is full of data and I've ordered the rows by date then when I import the...