"Do Not Report" Function when certain data is blank

  • Thread starter Thread starter Gary Jacobson
  • Start date Start date
G

Gary Jacobson

This may seem like the most lame question, but here goes:

I have put my local cemetery records in MS Access. The Burial Index lists
all burials alphabetically by last name. There are a lot of unused
gravesites in the cemetery, so when I generate the Index report, the first
17 pages are for the unused gravesites then the occupied ones show up. How
do I tell Access to not report the lines that have blanks in the name
fields?

Thanks!

Gary
 
Gary

Your description didn't mention it, but I would guess that you've based your
report on the table. If you want to select certain records (only the
occupied sites), use a query first, then base your report on the query.
 
Jeff,

Thanks for answering my stupid question. I figured it out myself right
after I posted it. :-\

Gary
 
Back
Top