October 2nd, 2003, 12:54 PM
|
|
Junior Member
|
|
Join Date: Jul 2003
Location: Western Massachusetts
Posts: 9
Time spent in forums: 32 m 54 sec
Reputation Power: 0
|
|
Crystal Reports query: Duplicate Names
I have a working Crystal Report that queries an Access Database for records of computers that have had certain updates done to them. This works fine.
The query keeps track of the computers: UserName, DateUpdated, and other things. How do I get the query to ignore earlier updates, and only show the latest one? I have tweaked the "Select Expert" section in the Report to a date that I know one of the updates was first available, but all people who were updated with the LAST update disappeared of course.
How can I keep the report showing only ONE record per computer of the LATEST update performed? Do I need to put the whole list into an array, and scan that for the latest date or something?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
