Only list last event in report

[Wolfgang]

Hi,

I am writing an access program. The program is designed to capture all the events (Telephone, contact or work done) by a company or individual to a database. This database will then be able to “track” the event.

I have created 2 tables one called matters (this table contains all the contact details, etc) and a second one called details(in the table are the details of the event, who captured it , etc) the two tables are linked by a common field MattersID.

The problem I a facing is: I would like to print a report with only the last event in it. I am able to create a report in almost any form (i.e. summary of all, this month, etc) but not this one.

Could you give me a pointer!

With many thanks

Wolfgang

 

[KevinM]

Create a query that sorts your events in descending order so the last one is first.
Then in the query properties select Top N values to show one and then base your report on this.

hth