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