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

T

Teoria

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.
 
R

Randy

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top