Trainer Report

[Gambler]

I am trying to link the trainer files to my access files. I have all the fields exported over, but when I make a relationship ( TRK, DATE, RACE, PROGRAM) in my query, I get a message TYPE MISMATCH IN EXPRESSION. Need advise.
Thanks
ed

[Rick]

Compare the two table field definitions.

They should be the same.

The date fields should both be Date/Time
The track fields should both be text
The race fields should both be byte
The program # fields should both be text

My guess is that you have the date field defined as text.

But that would just be the best place to start looking.

[Gambler]

That was it Rick.
Thanks
ed