Two possibilities come to mind. Most likely is that the Status field is numeric, and is expecting 1 (or the appropriate number) instead of "ACTIVO". The other possibility is that a field in the join has incompatible data types, like IdCli is a number in one table and text in the other.
Paul
--- In MS_Access_Professionals@yahoogroups.com, "rivera_vazquez_edgar" <xtintores@...> wrote:
>
> Hello again...
> So I've made all my tables, ralationships and forms and now I'm off to making the querys for my reports. I tried to make my first query and when I try to run it get a message that says "Data type mismatch in criteria expression".
>
> The SQL is:
>
> SELECT tblClients.Status, tblClients.Cuenta, tblClients.Company, tblClients.Tel1, tblClients.Tel2, tblClients.Tel3, tblContacts.Title, tblContacts.FirstName, tblContacts.MiddleName, tblContacts.LastName1, tblContacts.LastName2, tblContacts.Nickname, tblContacts.JobTitle, tblContacts.Tel4, tblContacts.Tel5, tblAddress.AddrType, tblAddress.Address, tblAddress.City, tblAddress.Tel6, tblAddress.Tel7
> FROM (((tblClients INNER JOIN tblContacts ON tblClients.IdCli = tblContacts.IdCli) INNER JOIN tblAddress ON tblClients.IdCli = tblAddress.IdCli) INNER JOIN tblClientInventory ON tblClients.IdCli = tblClientInventory.IdCli) INNER JOIN tblServices ON tblClientInventory.IdInven = tblServices.IdInven
> WHERE (((tblClients.Status)="ACTIVO"));
>
> Can someone rescue me out of this one?
> Thanks a lot, Edgar
>
Tidak ada komentar:
Posting Komentar