Customizing query/report

[Carrie]

Hello

I have a table called tbl_Values. In this table I have many fields - User ID, Date, Hours, Value1, Value2, ... I built two queries, one to return the fields User ID, Date, Hours, Value1 and the other to return the fields User ID, Date, Hours, Value2. The User ID, Date, and Hours will be same for both queries - just the Value1 and Value2 change. Here's my problem: a record may contain only one of the values (either Value1 or Value2) but in the corresponding query, because the info for User ID and Date are set, I will return just this info, but a null value for Value1/Value2. Is there a way to customize (using code) the query or report so that my query/report ignores records with null values? I would prefer not to split the table, but if this is the only option, so be it.

Thanks in advance
Carrie

 

[Ted]

Try entering "Is Not Null" in the criteria for the value
columns in the queries. Then each query will only return
records with entries for the included value column.

-----Original Message-----
Hello,

I have a table called tbl_Values. In this table I have

many fields - User ID, Date, Hours, Value1, Value2, ... I
built two queries, one to return the fields User ID,
Date, Hours, Value1 and the other to return the fields
User ID, Date, Hours, Value2. The User ID, Date, and
Hours will be same for both queries - just the Value1 and
Value2 change. Here's my problem: a record may contain
only one of the values (either Value1 or Value2) but in
the corresponding query, because the info for User ID and
Date are set, I will return just this info, but a null
value for Value1/Value2. Is there a way to customize
(using code) the query or report so that my query/report
ignores records with null values? I would prefer not to
split the table, but if this is the only option, so be
it.