| re: How to print section headers when no details.
I expect that your report is based on a query that includes 2 tables:
Locations and Clues. You need to modify the link between the 2 fields
in the query. To verify this, open the query iteslf and check on some
locations that have no clues - if not on the report, they should be not
on the query either. If they are there, then this is not your solution.
In the query's design view, right-click on the join line between the two
tables. (It's easy to miss the line by .1 mm. and get a wrong menu of 8
choices instead of two.) (IF there is no join line because you used a
where clause as another way to link the tables, you'll need to change it
to a join instead.) After right-clicking, select Join Properties and
select the option "Include all records from [the Locations table] and
only those from ..." This should be choice #2 or #3, not #1. This is
called an Outer Join, as opposed to your current Inner Join.
Now, in the grid's fields displaying Location information, make sure
they're from the Locations table, not from similar fields in the Clues
table. Have a look at the query's result before saving and going over
to work on the report - you should see all the locations listed. If
you've changed any fields in the query, check the report and verify the
data sources for your text boxes.
Bruce Pick
Sherwood Botsford wrote:[color=blue]
> I'm new to access.
>
> I have an orienteering database that has information about locations
> all
> over the map.
>
> Each location has 0-N clues
>
> I've worked up a report that will print the locations, with their
> associated information, and the clues that go with that.
>
> EXCEPT that if the number of clues is 0, the location doesn't print
> out.
>
> ***
> This must be a general issue. I'm just not asking the right questions.
> Suppose I had a customer list where I wanted
> to print outstanding invoices. I can see that I could want customers
> who
> had NO outstanding invoices to show up in the list.[/color]
| 
