better description (hopefully)

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

I am trying to get a report out of a single table. Some of
the records have several identical fields (for example
'start date/time', 'rcode') with only one different field
(called 'anumber').

How can I get the different fields, (called 'anumber') of
several records with the same start date to all print on a
report while just printing the identical fields for that
date/time once?

Example: using 4 records with anumbers 111,222,333,444

Start Date:
01/02/04
Anumber
111 222
333 444

Rcode
x022

What I am getting is :

Start Date:
01/02/04
Anumber
111 111
111 111

Rcode
x022

the A number of record 111 multiple times.
Thanks-Kathy
 
Kathy said:
I am trying to get a report out of a single table. Some of
the records have several identical fields (for example
'start date/time', 'rcode') with only one different field
(called 'anumber').

How can I get the different fields, (called 'anumber') of
several records with the same start date to all print on a
report while just printing the identical fields for that
date/time once?

Example: using 4 records with anumbers 111,222,333,444

Start Date:
01/02/04
Anumber
111 222
333 444

Rcode
x022

What I am getting is :

Start Date:
01/02/04
Anumber
111 111
111 111

Rcode
x022

the A number of record 111 multiple times.
Click to expand...


You can not get data from multiple records in a single
detail.

If you want the Anumber values to be in a single column,
then use the Sorting and Grouping feature (View menu) to
specify a group with header on the start date field. Put
the start date text box in the group header section and ,
just use one text box for the Anumber field in the detail
section.

If you want the Anumber values to be in multiple columns,
then you need to change the report's record source query to
only provide the start date values (using a Totals type
query). Then you can use a multi-column subreport to
display the Anumbers.
 
Back
Top