By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

How to print section headers when no details.

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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:
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.

Nov 12 '05 #2

P: n/a
This was the answer:
1. Changed the join option 2.
2. Changed the query from INNER JOIN to LEFT JOIN. (OUTER JOIN is not
syntactically valid...)
3. Set up the clue in the report as a subreport. (If I didn't do that the
location was printed for each clue.)
Bruce Pick <br********@comcast.net> wrote in message news:<J4********************@comcast.com>...
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.