Union Query WHERE clause

A

Alex

I'm trying to create a union query with the following SQL. I keep getting a
parameter prompt for all the fields in the WHERE clause except for Model,
which correctly prompts me for Model#. Any ideas what I'm doing wrong?
Thanks.

SELECT [Model#],[Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]
FROM ExcelBRefParts
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR (ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));

UNION SELECT [Model#], [Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC],[MatlLB],[VarLB], [NPCLB]
FROM ExcelB_Old
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR (ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));
 
J

John Spencer

Each query clause in a UNION query has to be able to execute on its own.
Your second query clause references fields in the table in the first query
clause and the first query clause references fields in the second table.

Beyond that I am at a loss as to exactly what you are attempting to do with
the query. Can you describe in english what you are attempting to do? For
example, I want to identify all the records in ExcelBRefParts that don't
exist in ExcelB_Old.
or I want to identify all the changes between tableA and TableB.

Both those would require someone of knowing which fields would match between
the two tables.



SELECT [Model#],[Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]
FROM ExcelBRefParts
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR (ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]))

UNION SELECT [Model#], [Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC],[MatlLB],[VarLB], [NPCLB]
FROM ExcelB_Old
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR (ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));


Alex said:
I'm trying to create a union query with the following SQL. I keep getting
a
parameter prompt for all the fields in the WHERE clause except for Model,
which correctly prompts me for Model#. Any ideas what I'm doing wrong?
Thanks.

SELECT [Model#],[Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]
FROM ExcelBRefParts
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));

UNION SELECT [Model#], [Part#], [AS Part#], [Matl Code], [FIN WTLB],
[Matl],
[Variable], [NPC],[MatlLB],[VarLB], [NPCLB]
FROM ExcelB_Old
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));
Click to expand...
 
A

Alex

Thanks John. I have two tables. In my query, I need to list the records
from both tables that have the same Model, Part and NHL, AND where one or
more of the following fields do not match: [Matl Code] [FIN WTLB] [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]. Thanks for your help.


John Spencer said:
Each query clause in a UNION query has to be able to execute on its own.
Your second query clause references fields in the table in the first query
clause and the first query clause references fields in the second table.

Beyond that I am at a loss as to exactly what you are attempting to do with
the query. Can you describe in english what you are attempting to do? For
example, I want to identify all the records in ExcelBRefParts that don't
exist in ExcelB_Old.
or I want to identify all the changes between tableA and TableB.

Both those would require someone of knowing which fields would match between
the two tables.



SELECT [Model#],[Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]
FROM ExcelBRefParts
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR (ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]))

UNION SELECT [Model#], [Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC],[MatlLB],[VarLB], [NPCLB]
FROM ExcelB_Old
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR (ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));


Alex said:
I'm trying to create a union query with the following SQL. I keep getting
a
parameter prompt for all the fields in the WHERE clause except for Model,
which correctly prompts me for Model#. Any ideas what I'm doing wrong?
Thanks.

SELECT [Model#],[Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]
FROM ExcelBRefParts
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));

UNION SELECT [Model#], [Part#], [AS Part#], [Matl Code], [FIN WTLB],
[Matl],
[Variable], [NPC],[MatlLB],[VarLB], [NPCLB]
FROM ExcelB_Old
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));
Click to expand...
Click to expand...
 
J

John Spencer

Thanks John. I have two tables. In my query, I need to list the records
from both tables that have the same Model, Part and NHL, AND where one or
more of the following fields do not match: [Matl Code] [FIN WTLB] [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]. Thanks for your help.

SELECT B.*, O.*
FROM ExcelBRefParts as B INNER JOIN ExcelB_Old as O
ON B.[Model#] = O.[Model#]
And B.[Part#] = O.[Part#]
And B.[NHL] = O.[NHL]
WHERE B.[Matl Code] <> O.[Matl Code] OR
B.[Fin WTLB] <> O.[Fin WTLB] OR
B.Matl <> O.Matl OR ...

Note: This won't pick up differences where one of the fields in the
comparison pairs is NULL. So, if those fields could be blank, you will need
to modify the where clause using the NZ function or more complex criteria
such as.

Where B.[Matl Code] <> O.[Matl Code] or
(B.[Matl Code] Is Null and O.[Matl Code] is Not Null) OR
(B.[Matl Code] Is Not Null and O.[Matl Code] is Null) OR
B.[Fin WTLB] <> O.[Fin WTLB] OR ...

Alex said:
Thanks John. I have two tables. In my query, I need to list the records
from both tables that have the same Model, Part and NHL, AND where one or
more of the following fields do not match: [Matl Code] [FIN WTLB] [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]. Thanks for your help.


John Spencer said:
Each query clause in a UNION query has to be able to execute on its own.
Your second query clause references fields in the table in the first
query
clause and the first query clause references fields in the second table.

Beyond that I am at a loss as to exactly what you are attempting to do
with
the query. Can you describe in english what you are attempting to do?
For
example, I want to identify all the records in ExcelBRefParts that don't
exist in ExcelB_Old.
or I want to identify all the changes between tableA and TableB.

Both those would require someone of knowing which fields would match
between
the two tables.



SELECT [Model#],[Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]
FROM ExcelBRefParts
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]))

UNION SELECT [Model#], [Part#], [AS Part#], [Matl Code], [FIN WTLB],
[Matl],
[Variable], [NPC],[MatlLB],[VarLB], [NPCLB]
FROM ExcelB_Old
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));


Alex said:
I'm trying to create a union query with the following SQL. I keep
getting
a
parameter prompt for all the fields in the WHERE clause except for
Model,
which correctly prompts me for Model#. Any ideas what I'm doing wrong?
Thanks.

SELECT [Model#],[Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]
FROM ExcelBRefParts
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));

UNION SELECT [Model#], [Part#], [AS Part#], [Matl Code], [FIN WTLB],
[Matl],
[Variable], [NPC],[MatlLB],[VarLB], [NPCLB]
FROM ExcelB_Old
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));
Click to expand...
Click to expand...
Click to expand...
 
A

Alex

Perfect - thank you so much John.

John Spencer said:
Thanks John. I have two tables. In my query, I need to list the records
from both tables that have the same Model, Part and NHL, AND where one or
more of the following fields do not match: [Matl Code] [FIN WTLB] [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]. Thanks for your help.

SELECT B.*, O.*
FROM ExcelBRefParts as B INNER JOIN ExcelB_Old as O
ON B.[Model#] = O.[Model#]
And B.[Part#] = O.[Part#]
And B.[NHL] = O.[NHL]
WHERE B.[Matl Code] <> O.[Matl Code] OR
B.[Fin WTLB] <> O.[Fin WTLB] OR
B.Matl <> O.Matl OR ...

Note: This won't pick up differences where one of the fields in the
comparison pairs is NULL. So, if those fields could be blank, you will need
to modify the where clause using the NZ function or more complex criteria
such as.

Where B.[Matl Code] <> O.[Matl Code] or
(B.[Matl Code] Is Null and O.[Matl Code] is Not Null) OR
(B.[Matl Code] Is Not Null and O.[Matl Code] is Null) OR
B.[Fin WTLB] <> O.[Fin WTLB] OR ...

Alex said:
Thanks John. I have two tables. In my query, I need to list the records
from both tables that have the same Model, Part and NHL, AND where one or
more of the following fields do not match: [Matl Code] [FIN WTLB] [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]. Thanks for your help.


John Spencer said:
Each query clause in a UNION query has to be able to execute on its own.
Your second query clause references fields in the table in the first
query
clause and the first query clause references fields in the second table.

Beyond that I am at a loss as to exactly what you are attempting to do
with
the query. Can you describe in english what you are attempting to do?
For
example, I want to identify all the records in ExcelBRefParts that don't
exist in ExcelB_Old.
or I want to identify all the changes between tableA and TableB.

Both those would require someone of knowing which fields would match
between
the two tables.



SELECT [Model#],[Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]
FROM ExcelBRefParts
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]))

UNION SELECT [Model#], [Part#], [AS Part#], [Matl Code], [FIN WTLB],
[Matl],
[Variable], [NPC],[MatlLB],[VarLB], [NPCLB]
FROM ExcelB_Old
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));


I'm trying to create a union query with the following SQL. I keep
getting
a
parameter prompt for all the fields in the WHERE clause except for
Model,
which correctly prompts me for Model#. Any ideas what I'm doing wrong?
Thanks.

SELECT [Model#],[Part#], [AS Part#], [Matl Code], [FIN WTLB], [Matl],
[Variable], [NPC], [MatlLB], [VarLB], [NPCLB]
FROM ExcelBRefParts
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));

UNION SELECT [Model#], [Part#], [AS Part#], [Matl Code], [FIN WTLB],
[Matl],
[Variable], [NPC],[MatlLB],[VarLB], [NPCLB]
FROM ExcelB_Old
WHERE (([Model#]=[forms]![Rpt_NewCostRollupChange]![Model]) AND
ExcelBRefParts.[Matl Code]<>[ExcelB_Old].[Matl Code] OR
(ExcelBRefParts.[FIN
WTLB]<>[ExcelB_Old].[FIN WTLB]) OR
(ExcelBRefParts.Matl<>[ExcelB_Old].[Matl]) OR
(ExcelBRefParts.Variable<>[ExcelB_Old].[Variable]) OR
(ExcelBRefParts.NPC<>[ExcelB_Old].[NPC]) OR
(ExcelBRefParts.MatlLB<>[ExcelB_Old].[MatlLB]) OR
(ExcelBRefParts.VarLB<>[ExcelB_Old].[VarLB]) OR
(ExcelBRefParts.NPCLB<>[ExcelB_Old].[NPCLB]));
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update value to null 1
Form troubles 0
Using WHERE clause when launching Reports from Code 4
Where clause with 2 criteria 6
Help with WHERE clause in query selecting from queries... 2
WHERE clause in query 4

Top