is not null returns "unknown"

M

maryj

A client has Office 2K/Win 2K. He's trying to run a query using the
criteria "is not null". The field is a text field. When he runs the
criteria - gets dialog box that says "unknown". The query works fine if
he enters in specific criteria.
 
J

John Vinson

A client has Office 2K/Win 2K. He's trying to run a query using the
criteria "is not null". The field is a text field. When he runs the
criteria - gets dialog box that says "unknown". The query works fine if
he enters in specific criteria.
Click to expand...

Please post the SQL view of the query. This *is* in Microsoft Access,
right? The "unknown" message would not appear to be coming from
Access; I wonder if there is some code in the form which is bringing
it up.

John W. Vinson[MVP]
 
M

maryj

Yes John, it is an Access query.
Here is the SQL:
SELECT [Bid Info].CustomerName, [General Info].BidNumber, [Bid Info].State,
[Bid Info].AwardDate, [Bid Info].ExpDate, [Bid Info].ContractRenewable, [Bid
Info].BU, [Product Info].Subset, [Product Info].Price, [General Info].Status,
[Product Info].AwardedTo, [Bid Requirements].FreeItems
FROM ((([Bid Info] INNER JOIN [Product Info] ON [Bid Info].gtMainDocUNID =
[Product Info].ParentID) INNER JOIN [Customer Info] ON [Bid
Info].gtMainDocUNID = [Customer Info].gtMainDocUNID) INNER JOIN [General
Info] ON ([Customer Info].gtMainDocUNID = [General Info].gtMainDocUNID) AND
([Bid Info].gtMainDocUNID = [General Info].gtMainDocUNID)) INNER JOIN [Bid
Requirements] ON ([General Info].gtMainDocUNID = [Bid
Requirements].gtMainDocUNID) AND ([Customer Info].gtMainDocUNID = [Bid
Requirements].gtMainDocUNID) AND ([Bid Info].gtMainDocUNID = [Bid
Requirements].gtMainDocUNID) AND ([Product Info].ParentID = [Bid
Requirements].gtMainDocUNID)
WHERE ((([Bid Info].CustomerName) Not Like "AAAA") AND (([Bid
Requirements].FreeItems) Is Not Null) AND (([Customer Info].docStatus) Not
Like "Archive"));

Hope that makes sense to you :)
 
Top