Pulling Most Recent Requests Only into Report

[Nicola]

Hello,

I am a novice to Access and have created a report with a list of all our
entered request in our system sorted by Customer. Each request however shows
up on our report and I only want to see the last request entered. ie. (We may
have Piggly Wiggly 3 times in the month of February but only want to see the
last entered request). Can you help with this or need more information?

 

[Klatuu]

How do you know which request was the last one?

 

[maceslin]

Hello,

I am a novice to Access and have created a report with a list of all our
entered request in our system sorted by Customer. Each request however shows
up on our report and I only want to see the last request entered. ie. (We may
have Piggly Wiggly 3 times in the month of February but only want to see the
last entered request). Can you help with this or need more information?

THis is my first advice to someone as I am also learning. I had to do
same thing.

You have to select most recent within your query statement. In the
query design grid find the column representing the date and in the
"total" row change the selection to "max", all other columns will be
"group by"

Good luck
Dave

 

[Nicola]

There's a time and date stamp behind the scenes. If I complete a request now
and then I complete another 1 hour from now I need the last request completed
to come through only.