[MS_AccessPros] Want to show only the most recent activity on an account

 

Good morning;

I'm hoping someone here can help me with this.

I'm trying to create a report that will show only the most recent activity on a certain account. I for the life of me cannot figure out how to do that.

My table has the following records ScheduleID, AccountId, ContactId, PersonnelId, ScheduleDate, Status, Type, Contact, Regarding, Result, Priority, AlarmDate, Activity, RequestId, DateOpened, DateClosed, ScheduleEndDate, SalesRep

ScheduleId is the unique ID for each entry, AccountID identifies the account, ScheduleDate is the date the activity is scheduled to happen, DateOpened is the date created and DateClosed is the date it was completed.

Hopefully this is enough information and someone will be able to help :)

- Brian Wood

I'm using Access 2010

Thanks :)

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6
• New Links 1
• New Files 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___