repeat information in report (Access 2007)

[john]

Hi,
My table contains the following fields and records:
first name surname
peter green
dave black
I now wish to utilise Report Design in order to create a report.In Design
View and in the Details section I arrange the textbox controls and what I see
is:
first name surname
first name surname
I then switch to Report View and what I see is:
first name surname
peter green
first name surname
dave black
I want first name and surname to appear once only and not twice.What I want
is:
first name surname
peter green
dave black
How do I achieve this?I read somewhere that I must look for the
HideDuplicates "entry" in the Property Sheet but I cannot find such an
"entry" there.
(I know that I can click on Tabular in the Control Layout group of the
Arrange tab to achieve such a "look" but then the label controls appear in
the Page Header section and I don't want them there because I have other
information entered there)
Any assistance would be appreciated.
john.

 

[Wayne-I-M]

Hi John

You have the put "first name surname" in the head of the sorting group so
you will have a header for each group - it looks like you have grouped your
report by name (or person) so you will have lots of headers

delete the text from the group header - put it in the page header or
somewhere else that you want.

Good luck

 

[john]

Hi Wayne-I-M,
Thanks for your reply.
I did not apply any grouping or sorting.I just clicked on Add Existing
Fields and then in the Field List pane I double clicked on first name and on
surname and then the two text box controls appeared in the Details section.I
did play around with Group and Sort a bit but I cannot achieve the results I
want in the Details section. (I also clicked on the label part of one text
box control and then clicked on Property sheet and in the Property sheet for
Labels I set "Visible" to "No" but that setting takes away all the labels.)
Regards,John

 

[Wayne-I-M]

The way to do these things is to try the most obvious first and then step
down the list of possible problems


OK - Next thing

I now wish to utilise Report Design in order to create a report.In Design
view and in the Details section I arrange the textbox controls and what I see
is:
first name surname
first name surname

You have first name surname "twice" so you will get the results twice ?

Can I suggest this -
Create a new report based on the same query/table.
Open the "blanc" report in design view.
On the View tab - select fields
Drag and drop the first name and surname fields into the design (once only)
- you need to drag them into the details row.
View the report is this correct.
If it is - then add 2 Lables (from the tool box) to the page header (if you
can't see this option use the View tab again and select Page Header)
"Don't" put the lables into the details row - or you will have the same
problem

Let us know if you are ok with this or you still have problems.

Note - don't worry about creating Lables yet - you can do that later. Just
get the basics right 1st, then just change the page setup to whatever you
want, like lables.

 

[john]

Hi Wayne-I-M,
You have shifted my thinking in the right direction and I am at last able to
create the desired report.
Thanks for your help.
Regards,
John