query not filtering according to form filter

J

JohnLute

I have a form that I use to filter a query. I'm having trouble with this:
[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]

[cbTestStrength] is a fixed/0 decimal formated combobox that queries the
fixed/0 decimal numeric field [TestStrength].

The query refuses to recognize the selection I make in [cbTestStrength].
It's bound column is 1 and it properly displays the selected value however
the query returns everything regardless.

All of the other filter controls work on the form filter except this one.

Any ideas?

Thanks!!!
 
K

KARL DEWEY

It's bound column is 1 and it properly displays the selected value however
the query returns everything regardless.

It should be UNBOUND!
 
J

JohnLute

Hi, Karl.

I'm sorry that I wasn't clear. It is indeed unbound however it queries:
SELECT tblPKCGMaterialAttributes.TestStrength FROM tblPKCGMaterialAttributes
GROUP BY tblPKCGMaterialAttributes.TestStrength HAVING
(((tblPKCGMaterialAttributes.TestStrength) Is Not Null)) ORDER BY
tblPKCGMaterialAttributes.TestStrength;

It's bound to column 1 of that Row Source.

All of the other controls query something, too and the query is happy to
filter what they display EXCEPT this one.

Have you ever encountered something like this?

--
www.Marzetti.com


KARL DEWEY said:
the query returns everything regardless.

It should be UNBOUND!

--
Build a little, test a little.


JohnLute said:
I have a form that I use to filter a query. I'm having trouble with this:
[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]

[cbTestStrength] is a fixed/0 decimal formated combobox that queries the
fixed/0 decimal numeric field [TestStrength].

The query refuses to recognize the selection I make in [cbTestStrength].
It's bound column is 1 and it properly displays the selected value however
the query returns everything regardless.

All of the other filter controls work on the form filter except this one.

Any ideas?

Thanks!!!
Click to expand...
Click to expand...
 
K

KARL DEWEY

Put the UNBOUND - repeat UNBOUND combo in the main form header, use it as
criteria in the query for the main form.

--
Build a little, test a little.


JohnLute said:
Hi, Karl.

I'm sorry that I wasn't clear. It is indeed unbound however it queries:
SELECT tblPKCGMaterialAttributes.TestStrength FROM tblPKCGMaterialAttributes
GROUP BY tblPKCGMaterialAttributes.TestStrength HAVING
(((tblPKCGMaterialAttributes.TestStrength) Is Not Null)) ORDER BY
tblPKCGMaterialAttributes.TestStrength;

It's bound to column 1 of that Row Source.

All of the other controls query something, too and the query is happy to
filter what they display EXCEPT this one.

Have you ever encountered something like this?

--
www.Marzetti.com


KARL DEWEY said:
It's bound column is 1 and it properly displays the selected value however
Click to expand...
the query returns everything regardless.

It should be UNBOUND!

--
Build a little, test a little.


JohnLute said:
I have a form that I use to filter a query. I'm having trouble with this:
[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]

[cbTestStrength] is a fixed/0 decimal formated combobox that queries the
fixed/0 decimal numeric field [TestStrength].

The query refuses to recognize the selection I make in [cbTestStrength].
It's bound column is 1 and it properly displays the selected value however
the query returns everything regardless.

All of the other filter controls work on the form filter except this one.

Any ideas?

Thanks!!!
Click to expand...
Click to expand...
Click to expand...
 
J

JohnLute

Karl,

I appreciate your time. I'm afraid we're on different pages.

The form that the control is on is UNBOUND. The form has several unbound
controls to make selections that a query uses to filter. The form has a
button to fire up the query.

All of the controls on the form are located in the detail section. The query
filters according to all of them except this particular control. Regardless
of what's selected and displayed in the control the query returns ALL.

Could the query or form be corrupted in some way...?

--
www.Marzetti.com


KARL DEWEY said:
Put the UNBOUND - repeat UNBOUND combo in the main form header, use it as
criteria in the query for the main form.

--
Build a little, test a little.


JohnLute said:
Hi, Karl.

I'm sorry that I wasn't clear. It is indeed unbound however it queries:
SELECT tblPKCGMaterialAttributes.TestStrength FROM tblPKCGMaterialAttributes
GROUP BY tblPKCGMaterialAttributes.TestStrength HAVING
(((tblPKCGMaterialAttributes.TestStrength) Is Not Null)) ORDER BY
tblPKCGMaterialAttributes.TestStrength;

It's bound to column 1 of that Row Source.

All of the other controls query something, too and the query is happy to
filter what they display EXCEPT this one.

Have you ever encountered something like this?

--
www.Marzetti.com


KARL DEWEY said:
It's bound column is 1 and it properly displays the selected value however
the query returns everything regardless.

It should be UNBOUND!

--
Build a little, test a little.


:

I have a form that I use to filter a query. I'm having trouble with this:
[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]

[cbTestStrength] is a fixed/0 decimal formated combobox that queries the
fixed/0 decimal numeric field [TestStrength].

The query refuses to recognize the selection I make in [cbTestStrength].
It's bound column is 1 and it properly displays the selected value however
the query returns everything regardless.

All of the other filter controls work on the form filter except this one.

Any ideas?

Thanks!!!
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

Post the SQL of your query.

--
Build a little, test a little.


JohnLute said:
Karl,

I appreciate your time. I'm afraid we're on different pages.

The form that the control is on is UNBOUND. The form has several unbound
controls to make selections that a query uses to filter. The form has a
button to fire up the query.

All of the controls on the form are located in the detail section. The query
filters according to all of them except this particular control. Regardless
of what's selected and displayed in the control the query returns ALL.

Could the query or form be corrupted in some way...?

--
www.Marzetti.com


KARL DEWEY said:
Put the UNBOUND - repeat UNBOUND combo in the main form header, use it as
criteria in the query for the main form.

--
Build a little, test a little.


JohnLute said:
Hi, Karl.

I'm sorry that I wasn't clear. It is indeed unbound however it queries:
SELECT tblPKCGMaterialAttributes.TestStrength FROM tblPKCGMaterialAttributes
GROUP BY tblPKCGMaterialAttributes.TestStrength HAVING
(((tblPKCGMaterialAttributes.TestStrength) Is Not Null)) ORDER BY
tblPKCGMaterialAttributes.TestStrength;

It's bound to column 1 of that Row Source.

All of the other controls query something, too and the query is happy to
filter what they display EXCEPT this one.

Have you ever encountered something like this?

--
www.Marzetti.com


:

It's bound column is 1 and it properly displays the selected value however
the query returns everything regardless.

It should be UNBOUND!

--
Build a little, test a little.


:

I have a form that I use to filter a query. I'm having trouble with this:
[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]

[cbTestStrength] is a fixed/0 decimal formated combobox that queries the
fixed/0 decimal numeric field [TestStrength].

The query refuses to recognize the selection I make in [cbTestStrength].
It's bound column is 1 and it properly displays the selected value however
the query returns everything regardless.

All of the other filter controls work on the form filter except this one.

Any ideas?

Thanks!!!
Click to expand...
Click to expand...
Click to expand...
 
J

JohnLute

Oh, boy, Karl. It's a biggie. I just tried and I went over the 30000
character limit (33677). I went back and edited the query to eliminate
non-essentials:

SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength, tblPKCGMaterialAttributes.TSUOM,
tblPKCGMaterialAttributes.OutsideLinerMaterial, Trim([1FluteType] &
(+[2FluteType]) & (+[3FluteType])) AS Flute, [OutsideLinerWeight] &
("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) & ("-"+[2MediumWeight]) &
("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) & ("-"+[4LinerWeight]) AS Liner
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID
WHERE
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner]))) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner]))) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner]))) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner]))) OR
(((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is
Null)) OR
(((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is
Null)) OR
(((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is
Null)) OR
(((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is
Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM]) Is
Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM]) Is
Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM]) Is
Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM]) Is
Null)) OR
(((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND (([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
Is Null)) OR
(((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND (([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
Is Null)) OR
(((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND (([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
Is Null)) OR
(((tblPKCGMaterialAttributes.OutsideLinerMaterial)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND (([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
Is Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND
((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR
(((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR
(((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR
(((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR
(((tblPKCGMaterialAttributes.TSUOM)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM]) Is
Null) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM]) Is
Null) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM]) Is
Null) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength])
AND ((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM]) Is
Null) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR (((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND (([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
Is Null) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR (((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND (([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
Is Null) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR (((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND (([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
Is Null) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null)) OR (((Trim([1FluteType] & (+[2FluteType]) & (+[3FluteType]))) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbFlute])) AND
(([OutsideLinerWeight] & ("-"+[1MediumWeight]) & ("-"+[2LinerWeight]) &
("-"+[2MediumWeight]) & ("-"+[3LinerWeight]) & ("-"+[3MediumWeight]) &
("-"+[4LinerWeight])) Like
IIf([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner] Is
Null,"*",[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbLiner])) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]) Is Null)
AND (([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrengthUOM])
Is Null) AND
(([Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbOutsideLinerMaterial])
Is Null));
 
K

KARL DEWEY

Try query like this to see what it is feeding to your query.
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength,
[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID;
 
J

JohnLute

Ok, Karl. I hope I'm following you. I used this as the query and it returned
an expression field with all nulls right next to the [TestStrength] column
which was populated with 360 values.

I then tried this:
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID
WHERE
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]));

It returned one null record!

I then tried this:
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID;

It returned all 360 records and values!

This is truly bizarre.
 
K

KARL DEWEY

it returned an expression field with all nulls right next to the
[TestStrength] column
Did you make a selection of TestStrength?
If you made a selection of TestStrength combo it should have returned the
criteria you were using.
--
Build a little, test a little.


JohnLute said:
Ok, Karl. I hope I'm following you. I used this as the query and it returned
an expression field with all nulls right next to the [TestStrength] column
which was populated with 360 values.

I then tried this:
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID
WHERE
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]));

It returned one null record!

I then tried this:
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID;

It returned all 360 records and values!

This is truly bizarre.

--
www.Marzetti.com


KARL DEWEY said:
Try query like this to see what it is feeding to your query.
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength,
[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID;
Click to expand...
Click to expand...
 
J

JohnLute

Karl,
Did you make a selection of TestStrength?
If you made a selection of TestStrength combo it should have returned the
criteria you were using.
Click to expand...

Yes, I did and no, it did not! I'm not new to this kind of thing and this is
why I'm completely puzzled!

Have I stumbled on an Access glitch...??? I can't see ANYTHING wrong with
the design. Also, Access doesn't give any error messages.

What the heck!

--
Build a little, test a little.


JohnLute said:
Ok, Karl. I hope I'm following you. I used this as the query and it returned
an expression field with all nulls right next to the [TestStrength] column
which was populated with 360 values.

I then tried this:
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID
WHERE
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]));

It returned one null record!

I then tried this:
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID;

It returned all 360 records and values!

This is truly bizarre.

--
www.Marzetti.com


KARL DEWEY said:
Try query like this to see what it is feeding to your query.
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength,
[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID;
Click to expand...
Click to expand...
Click to expand...
 
J

JohnLute

ARRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRGGGGGGGGGGGGGGGGHHHHHHHHHHH!!!!

I can't BELIEVE how I missed this!!! I went back and looked at the form
design for the BILLIONTH time and found that [cbTestStrength] was improperly
named [cbTestStength]

GEEEEEEZZZZ! I'm sorry for wasting your time like this. How embarrassing!!!

--
www.Marzetti.com


KARL DEWEY said:
[TestStrength] column
Did you make a selection of TestStrength?
If you made a selection of TestStrength combo it should have returned the
criteria you were using.
--
Build a little, test a little.


JohnLute said:
Ok, Karl. I hope I'm following you. I used this as the query and it returned
an expression field with all nulls right next to the [TestStrength] column
which was populated with 360 values.

I then tried this:
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID
WHERE
(((tblPKCGMaterialAttributes.TestStrength)=[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]));

It returned one null record!

I then tried this:
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID;

It returned all 360 records and values!

This is truly bizarre.

--
www.Marzetti.com


KARL DEWEY said:
Try query like this to see what it is feeding to your query.
SELECT tblPKCGMaterialAttributes.txtProfileID AS ID,
tblPKCGMaterialAttributes.TestStrength,
[Forms]![frmQueryPKCGPhysicalMaterialAttributes]![cbTestStrength]
FROM qryPhysicalAttributes INNER JOIN tblPKCGMaterialAttributes ON
qryPhysicalAttributes.txtProfileID = tblPKCGMaterialAttributes.txtProfileID;
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

Multiple Parameter Crosstab query filter by form 1
Query taking too long to open 4
Changing query criteria to supply a form 3
Using Format Property to set fixed decimals 1
Query Criteria from Form Problem 7
Using Filter by Form to create a Query and then a Report 6
Open Query to Filter by Form 4
Unable to use filter in datasheet view or add criteria to query indesign view 2

Top