473,326 Members | 2,128 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

How to print section headers when no details.

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
2 1976
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Meena | last post by:
Hi Every Body, I have created a crystal Report and linked to my vb.net forms and working fine, I added more drill drowns in groups everything fine, but What I need is I am not able to display...
3
by: John Peterson | last post by:
Hello all! I'm at my wits end trying to search for what I assumed to be a relatively straightforward task. I have a Web application written in C#, and I have a button on the form that I want to...
6
by: CSharpguy | last post by:
In my gridview I have 2 -3 template fields which are hyperlinks. I allow the user to print this grid. When the grid prints it also prints the links, how can I take the user to a print preview page...
0
by: John Smith | last post by:
Hello, I am developing a VB.NET 2003 application that will use lots of Crystal Reports. Sometimes the users will preview a report in a Crystal report viewer, and sometimes they will send the...
45
by: Umesh | last post by:
please help. thanks.
0
by: peter.c.bradley | last post by:
Hi folks, I have an Access report that has an unbound text box in the details section. The report also includes the standard headers and footers. The details section is populated by a query...
3
by: Tim | last post by:
Folks, I'm trying to format a print string so that it reports progress whilst processing a looping structure with a date time stamp appended to the end of the string. This started out life as a...
2
by: dmorand | last post by:
When I try to print a 'print version' of my page it looks fine in IE 7, but when I print in IE 6 the margins are all screwed up. The page itself looks the same in both browsers, it's just when I...
1
by: altaey | last post by:
Question Details: Write a program to find and print a Fibonacci sequence of numbers. The Fibonacci sequence is defined as follow: Fn = Fn-2 + Fn-1, n >= 0 F0 = 0, F1 = 1, F2 = 1 Your...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.