Access: Multiple transaction dates (displaying last one) for one .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I generate a report where I can have multiple listings under the same
header. (i.e multiple transaction dates (but only displaying the last date in
the report) and I want the transaction dates to be displayed corresponding to
only one company name. I do not want a table that lists the company name for
every date entered. List the name once and have the last date from another
table or whatever displayed. On that other table, list the company once and
then in a second column list all pertaining dates to that one company listing.
 
Teoria said:
How do I generate a report where I can have multiple listings under the
same
header. (i.e multiple transaction dates (but only displaying the last date
in
the report) and I want the transaction dates to be displayed corresponding
to
only one company name. I do not want a table that lists the company name
for
every date entered. List the name once and have the last date from another
table or whatever displayed. On that other table, list the company once
and
then in a second column list all pertaining dates to that one company
listing.
Click to expand...

Teoria, you need to use grouping in your report. You should group by the
company name, so it can be listed once and instead of once for each record.

-Randy
 
Back
Top