Pull data last entered by date/time stamp Access 2003

[amanda27]

I have a database that we use in our department for the status of our projects. In the form when you pick a project from the dropdown list I have a subform that pulls the data entered for the following week. I was able to do this by having when they input data it automatically pulls the date for week ending by this: =DateAdd("d",6-Weekday(Date()),Date()),
so therefore to see previous weeks data the subform date field has this: =DateAdd("d",-7,[Forms]![Enter Status for New Week Data]![DateOfWeekEnding])
Because they may have changes to make within that week to what they already input I would like for them to be able to pull last entered data for that certain project instead of the previous weeks. I have added a datetime stamp field to the subform but can not figure out what the criteria would be to have it read the last one entered. Can anyone help me with this?
Thanks

[MMcCarthy]

Not sure exactly what you're asking but does this work?

=Max([Forms]![Enter Status for New Week Data]![DateOfWeekEnding]) 

Mary

[amanda27]

Well what I ended up doing was putting a query together that the report is reading from and so for the datetimestamp I grouped by Max then had it go in descending order. That way I bring the last entry to the top per each project description. However it is still bringing every record into the table. How do I only bring in the last entered record per project description?

Not sure exactly what you're asking but does this work?

=Max([Forms]![Enter Status for New Week Data]![DateOfWeekEnding]) 

Mary

[MMcCarthy]

Well what I ended up doing was putting a query together that the report is reading from and so for the datetimestamp I grouped by Max then had it go in descending order. That way I bring the last entry to the top per each project description. However it is still bringing every record into the table. How do I only bring in the last entered record per project description?

Post the SQL of the query you are currently using.

[amanda27]

There are a lot of fields in this query. Here is what I want though. I want it to pull the last record entered for a specified Date of Week Ending for all current projects:
SELECT Max(Status_Fields.DateTimeStamp) AS MaxOfDateTimeStamp, Status_Fields.Date_Of_Week_Ending, Status_Fields.Master_Project_Name, Status_Fields.Status_Description, Status_Fields.Supervisor, Status_Fields.Description_Name1, Status_Fields.Description_Name2, Status_Fields.Description_Name3, Status_Fields.Description_Name4, Status_Fields.Description_Name5, Status_Fields.Summary_Rating, Status_Fields.Status_for_Week_Ending, Status_Fields.Next_Milestone, Status_Fields.Next_Steps, Status_Fields.ImagePath
FROM Status_Fields
GROUP BY Status_Fields.Date_Of_Week_Ending, Status_Fields.Master_Project_Name, Status_Fields.Status_Description, Status_Fields.Supervisor, Status_Fields.Description_Name1, Status_Fields.Description_Name2, Status_Fields.Description_Name3, Status_Fields.Description_Name4, Status_Fields.Description_Name5, Status_Fields.Summary_Rating, Status_Fields.Status_for_Week_Ending, Status_Fields.Next_Milestone, Status_Fields.Next_Steps, Status_Fields.ImagePath
ORDER BY Max(Status_Fields.DateTimeStamp) DESC;

Post the SQL of the query you are currently using.

[MMcCarthy]

Try this ...

SELECT Status_Fields.Master_Project_Name,
Max(Status_Fields.DateTimeStamp) AS MaxOfDateTimeStamp,
First(Status_Fields.Date_Of_Week_Ending),
First(Status_Fields.Status_Description), 
First(Status_Fields.Supervisor), 
First(Status_Fields.Description_Name1),
First(Status_Fields.Description_Name2), 
First(Status_Fields.Description_Name3), 
First(Status_Fields.Description_Name4),
First(Status_Fields.Description_Name5), 
First(Status_Fields.Summary_Rating),
First(Status_Fields.Status_for_Week_Ending),
First(Status_Fields.Next_Milestone), 
First(Status_Fields.Next_Steps), 
First(Status_Fields.ImagePath)
FROM Status_Fields
GROUP BY Status_Fields.Master_Project_Name 
ORDER BY Max(Status_Fields.DateTimeStamp) DESC;