It's like asking a mechanic to fix your flat tire without bringing the car in. That's just not gonna work.

Mine too since she didn't use the correct join syntaxe everytime she posted but that's another story.

The same still applies.

Post :

- Table definitions

- sample data

- wrong resultset

- expected resultset

Had already forgot about that "great uproar" thread .

, you should start a new thread with that.

This in a non-smoking buidling??? They'll get your head for this, you'd better stop right now .

She doesn't have that killer instinct... I wouldn't worry too much about it if I were me .

Don't remember who said that but : You're always right when I'm not wrong .

Still fumigating on that guess?

I see. I've never faced that problem and I can't think of a solution at the moment... maybe someone else will be in a better position to help you.

Still no change there .

Sorry mick, I missed the part where you said read before posting the question. I shouldn't have gone off like that.

Here are the passages you missed :

Does this have to be run as an SP or can the code be fired from another application?

You can delete the post using the edit button / delete

Maybe one fo the possible causes... Access will try todo the most work it can on the sql server, but at some point, more than necessary data will be sent...

where insert_date is null