Difficult Report

[sturner333]

I am trying to do an complicated report and am looking for some ideas on how
to do it. This hard to explain ( I think), but what I want to do is run a
report based on

project category
project number
and all notes that where entered for those projects

The tricky part is if there is a project under a project category that has
no note I would like to leave a "placeholder" or dummy entry for that project
number along with the engineers name that should have made a note. I can do
this in a query or I can use VBA, whatever gets the job done. All this
information is available from the same table.

Maybe I am making this harder than it looks or it may be not practical.
Thanks for the help!

 

[Evi]

We probably need to know about your table structure but you could put a
Default value in the Table which refers to a 'dummy' record which can have
"" in the bit you can see. Ensure that the field is set up to Allow Zero
Length String so that there will always be an entry, which you can then
filter out when you need to.
Evi

 

[John Spencer]

Perhaps all you need to do is use the nz function in your query.

Nz([Note],[Engineer])

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================