K
Keith
In the following query, I am getting the "data type mismatch in criteria
expression" error. It's kind of weird, because the datasheet view appears to
be normal behind the error popup, but after I click ok all the fields change
to #Name. Here is the query:
SELECT qryJobs.JOB_NO, qryJobs.[PURCHASE ORDER NUMBER], qryJobs.PNFixed,
[PART MASTER].[REF #], [PART MASTER].[PART DESCRIPTION], [PART
MASTER].MATERIAL, [PART MASTER].Finish, [PART MASTER].HeatTreat
FROM qryJobs INNER JOIN [PART MASTER] ON (qryJobs.CUSTOMER = [PART
MASTER].CUSTOMER) AND (qryJobs.PNFixed = [PART MASTER].PART_NO);
One confession (which is probably relevant): There is a relationship
between the PART_NO field in the table upon which qryJobs is based and the
PART_NO field in the [PART MASTER] table. I am actually trying to circumvent
this in this query by instead relating the qryJobs.PNFixed and [PART
MASTER].PART_NO fields. I'm guessing that this is the source of my problem.
I was hoping to avoid using a bunch of DLookups because they perform so
slowly on larger tables/queries. Does anyone have any advice?
Thanks,
Keith
expression" error. It's kind of weird, because the datasheet view appears to
be normal behind the error popup, but after I click ok all the fields change
to #Name. Here is the query:
SELECT qryJobs.JOB_NO, qryJobs.[PURCHASE ORDER NUMBER], qryJobs.PNFixed,
[PART MASTER].[REF #], [PART MASTER].[PART DESCRIPTION], [PART
MASTER].MATERIAL, [PART MASTER].Finish, [PART MASTER].HeatTreat
FROM qryJobs INNER JOIN [PART MASTER] ON (qryJobs.CUSTOMER = [PART
MASTER].CUSTOMER) AND (qryJobs.PNFixed = [PART MASTER].PART_NO);
One confession (which is probably relevant): There is a relationship
between the PART_NO field in the table upon which qryJobs is based and the
PART_NO field in the [PART MASTER] table. I am actually trying to circumvent
this in this query by instead relating the qryJobs.PNFixed and [PART
MASTER].PART_NO fields. I'm guessing that this is the source of my problem.
I was hoping to avoid using a bunch of DLookups because they perform so
slowly on larger tables/queries. Does anyone have any advice?
Thanks,
Keith