Query - Obtaining Specific Dates

[StateGov]

Can anyone tell me how I would add information to a query that would allow me obtain the LastUpdate to a particular field. I.E. I have a database where a user updates particular estimates, however, all estimates are retained in this dbase...I would like to pull out the last date for a particular update. I have tried DMax, however, it just applied today's date to the field. Any thoughts on this?

Any assistance would be greatly appreciated.

 

[PaulBricker]

What did your DMax statement look like? Also, how is the date field in your Table set up.

Paul

 

[StateGov]

The data that appears in the field appears as below:

4/2/2001 11:16:04 AM

The query statement is as follows:

Last Update: DMax("[Last_Update]","dbo_tbl_Project_Estimate&quot or Last Update:
DMin("[Last_Update]","dbo_tbl_Project_Estimate&quot

When using DMax, 10/21/2002 1:54:36 PM is the returned data

When using Dmin, 1/2/1997 is the returned data

These are only some of the dates that reside in this dbase. This date varies and I am attempting to pull the earliest entry date for each record and the latest entry dates (sep. queries of course).

Any suggestions?

 

[PaulBricker]

Can you create a Totals query that uses some value in the Record, like OrderNumber, and Group's By that number and then add the DateField twice and set the Totals line for Max on one and Min on another. This should give you the values you want. It will really depend on whether you can come up with a Field to Group By.

Paul