I'm glad you've got your answer (actually, I'm a little puzzled about
the answer), but I just needed to throw this in:

SELECT tblContact.ContactID, tblContact.CaseID, tblContact.Date
You should stop using "Date" as a field name. It's a reserved keyword
(being the name of a VBA function) and its use as a field name will
cause you problems down the road. If it is not too late in the design
process, you should change that fieldname to something more meaningful
(ContactDate?) so as to avoid the reserved keyword issues.

Tara wrote:
I can't believe it took three people to make me see this! I guess
I'd just been at it too long because when I came back in this morning
and read the comments over again, I realized immediately you were all
right. I guess my brain was just too overworked. It really needed
the weekend off.



--
HTH,
Bob Barrows