Jump to content
  • 0

Report to fetch the latest entry for a particular field



I have a table with measurement information for various facilities. Each measurement has a measurement date. Facility name is the search criteria for a report. When a user chooses a particular facility, I want the report to display the latest measurement (based on the measurement date). Currently it displays all the measurement information. However, the requirement is to see only the latest information.

Any help will be greatly appreciated.

Thanks !

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

I assume this was bumped for my benefit. I had actually seen this thread before I posted my question. While this will work, I would much prefer for the secretary not to have to run two reports. She is not the most computer-literate person around and I am trying to keep things as simple as possible for her.

But thanks anyway. I'll keep this as my plan B.


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...