Re: Pulling Most Recent Requests Only into Report

On Mar 10, 3:54 pm, Nicola <Nic...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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
.