No records show

P

Philip

I have added a field to a table and now I want to add
that field to set a paramater in a query (I already have
3 other and they work fine) but when I add this paramater
I get no records. I did set the or criteria to "is null"

Thank you

Phil
 
J

Jeff Boyce

Phil

Are you certain the field contains Null, and not a zero-length string?

If you build a new query that only returns that one (new) field, and use Is
Null for the criterion, how many rows do you get?

Can you post your SQL statement for us?
 
G

Guest

Thank you here is SQL for the query. I have a form
sitting on top of the query with combo boxes to fill in
the values for criteria.

SELECT tbSummary.Vendor, tbStyles.ProductDescription,
tbSummary.ProductNumber, tbSummary.Price, tbSummary.Date,
tbSummary.Color, tbSummary.Fabric, tbSummary.Division,
tbSummary.Season, tbSummary.[Price Kilo / Yard Width],
tbSummary.Memo, tbSummary.SpecialProjects
FROM tbStyles INNER JOIN tbSummary ON
tbStyles.ProductNumber = tbSummary.ProductNumber
WHERE (((tbSummary.Vendor) Like [Forms]!
[frReportSwitchBoard]![Vendor] & "*") AND
((tbSummary.ProductNumber) Like [Forms]!
[frReportSwitchBoard]![ProductNumber] & "*") AND
((tbSummary.Division) Like [Forms]![frReportSwitchBoard]!
[Division] & "*") AND ((tbSummary.Season) Like [Forms]!
[frReportSwitchBoard]![Season] & "*") AND
((tbSummary.SpecialProjects) Like [Forms]!
[frReportSwitchBoard]![Combo14] & "*")) OR
(((tbSummary.Vendor) Is Null) AND
((tbSummary.ProductNumber) Is Null) AND
((tbSummary.Division) Is Null) AND ((tbSummary.Season) Is
Null) AND ((tbSummary.SpecialProjects) Is Null));
 
J

Jeff Boyce

....and what happens when you do the single field query on the new field,
with Is Null?
 
Top