Query report

[ICTkirsten]

Hi,

I am trying to create a query for the foundations of my report that should display each dentist schedule for each day..

I have done this so far but the query will not run because it says ''data type mismatch in criteria mismatch"...

I might be doing the query entirely wrong
Could someone take a look at my query attached

P.s. pink is DentistID ive covered it for a lengthly reason that hopefully nobody is too bothered about

thank you )

 

[pbaldy]

One possibility is that the fields being joined on have different data types in each table.

 

[CJ_London]

I think it is more likely it is because you are trying to get a var (variance) value for a text value - i.e. forename, surname