No records show

  • Thread starter Thread starter Philip
  • Start date Start date
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
 
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?
 
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));
 
....and what happens when you do the single field query on the new field,
with Is Null?
 
Back
Top