ACCESS FEED: RE: [MS_AccessPros] Get dataset filter help

Rabu, 05 Agustus 2015

RE: [MS_AccessPros] Get dataset filter help

Drag down your TPTID & CORRESPONDENCE DATE fields.

Use the Sigma on your toolbar for a 'summary' type query. Set the date field to use MAX instead of group.

7ony

Sent from my Verizon Wireless 4G LTE smartphone

-------- Original message --------

From: "desertscroller@cox.net [MS_Access_Professionals]"

Date:08/04/2015 11:24 PM (GMT-05:00)

To: MS_Access_Professionals@yahoogroups.com

Subject: [MS_AccessPros] Get dataset filter help

I have a query that returns a set of data that includes multiples of an id. The records contain the same kind of data but the dates will vary. What I am trying to do is filter the data to include only one record per id with the most recent dates. I have a query that groups all records based on the id with the most recent dates first but can not seem to filter the data set to a subset that only includes the record for each id with the most recent dates. (This will be used to generate a status report of id activity. Example: The two excerpts from the data set but only want to have only the first record for each lngTPTID in new data set.

Any suggestions would be a great help.
Rod


AuditorName	strTaxPayerName	lngTPTID	Research Date	LastCorrespondence
Bedsun, Robert	VCCA GILBERT INVESTORS LLC	24588	9/15/2013	8/3/2015
Bedsun, Robert	VCCA GILBERT INVESTORS LLC	24588	9/15/2013	7/22/2015
Bedsun, Robert	VCCA GILBERT INVESTORS LLC	24588	9/15/2013	9/30/2013