query not filtering according to form filter

  • Thread starter Thread starter JohnLute
  • Start date Start date
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!!!
 
It's bound column is 1 and it properly displays the selected value however
the query returns everything regardless.

It should be UNBOUND!
 
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...
 
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...
 
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...
 
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...
 
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));
 
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;
 
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.
 
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...
 
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...
 
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...
 
Back
Top