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 contact with that 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 ,when it was captured, 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 newest(latest
) 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
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 ,when it was captured, 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 newest(latest
) 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
