Subject: Report - If null set the text boxes visible to false

[Guest]

I have a report which displays the hours worked on a project or category. It
gets the information from a time card table which has the field names
Category Name Text
Project Name Text
Hours Number

Either Category Name is null or Project Name is null for every record.
Now i want my report to display all the hours worked on the category/project
names, so that it looks like this.

Vacation 5
Health Management 10

However im having probelems because my report displays the hours for all the
records even if there is a null record for the Category Name or Project Name.
I guess I want to know if there was a way that I can set the hours visible to
false when project name/category name is null.

I have tried seprating the time card into 2 but then other problems arise
when i try to combine the two time cards into one report.

If anyone can help i would greatly appreciate it.
Thanks

 

[Marshall Barton]

I have a report which displays the hours worked on a project or category. It
gets the information from a time card table which has the field names
Category Name Text
Project Name Text
Hours Number

Either Category Name is null or Project Name is null for every record.
Now i want my report to display all the hours worked on the category/project
names, so that it looks like this.

Vacation 5
Health Management 10

However im having probelems because my report displays the hours for all the
records even if there is a null record for the Category Name or Project Name.
I guess I want to know if there was a way that I can set the hours visible to
false when project name/category name is null.

Create a query to combine the two fields:

SELECT somefields,
Nz([Category Name], [Project Name]) As CatProj
FROM timecards

 

[Guest]

Thanks

I have a report which displays the hours worked on a project or category. It
gets the information from a time card table which has the field names
Category Name Text
Project Name Text
Hours Number

Either Category Name is null or Project Name is null for every record.
Now i want my report to display all the hours worked on the category/project
names, so that it looks like this.

Vacation 5
Health Management 10

However im having probelems because my report displays the hours for all the
records even if there is a null record for the Category Name or Project Name.
I guess I want to know if there was a way that I can set the hours visible to
false when project name/category name is null.

Create a query to combine the two fields:

SELECT somefields,
Nz([Category Name], [Project Name]) As CatProj
FROM timecards