I have a query where a user is loging information on a monthly basis. We are monitoring changes in performance. the issue I am having is getting the query to show the most current date
Client Code DateChecked ASP Capacity ASP Percent
BI 4/5/2004 3.93G 85.8167
BI 5/6/2004 3.93G 87.2490
BI 6/14/2004 3.93G 87.2490
BI 7/14/2004 3.93 G 89.0868
CV 3/29/2004 17.18G 91.7392
CV 5/6/2004 17.18G 91.4153
CV 6/14/2004 17.18G 90.5943
LA 5/6/2004 16.77G 86.8870
LA 6/10/2004 16.77G 86.8870
LA 6/30/2004 16.77G 89.1083
LA 7/26/2004 16.77 G 89.4949
PEDC 3/29/2004 1389M 85.6482
PEDC 5/10/2004 1389M 93.5391
For Client BI through PEDC, I just want the most current date since it is the most current record of that client.
What would I put in the criteria to get this right?
Thanks,
Krash
Client Code DateChecked ASP Capacity ASP Percent
BI 4/5/2004 3.93G 85.8167
BI 5/6/2004 3.93G 87.2490
BI 6/14/2004 3.93G 87.2490
BI 7/14/2004 3.93 G 89.0868
CV 3/29/2004 17.18G 91.7392
CV 5/6/2004 17.18G 91.4153
CV 6/14/2004 17.18G 90.5943
LA 5/6/2004 16.77G 86.8870
LA 6/10/2004 16.77G 86.8870
LA 6/30/2004 16.77G 89.1083
LA 7/26/2004 16.77 G 89.4949
PEDC 3/29/2004 1389M 85.6482
PEDC 5/10/2004 1389M 93.5391
For Client BI through PEDC, I just want the most current date since it is the most current record of that client.
What would I put in the criteria to get this right?
Thanks,
Krash