Latest update displayed only!

  • Thread starter Thread starter Jim P
  • Start date Start date
J

Jim P

I have created a database to track company projects.
What I want to be able to do is have an individual update
their projects on an on-going basis; however, when I
print the report out for all projects, I only want the
latest update to a project and not all the prior
updates. Can this be done?
 
You can use a date field and and the project name field.
Create a query, group projects by name and then use the
max function for the date. Add this query to the query
that prepares the report and left click and drag project
name to project name and date to date. Right click on the
relationship lines if needed and ensure that it reads to
only display records where both queries match. If you also
like to maintain an overall history, the do this:
1. Copy and rename your original query.
2. Add your new query to your copied original query.
Follow the rules above for creating a relationship.
3. Copy the report and make the source data the name of
the new query.
4. If there is a form you can add a button, so you can
pick what report you want to see.

Chris
 
Back
Top