Pulling Most Recent Requests Only into Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nicola - 10 Mar 2008 20:54 GMT

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?

Reply to this Message

Klatuu - 10 Mar 2008 21:03 GMT

How do you know which request was the last one?

Signature

Dave Hargis, Microsoft Access MVP

> Hello,
>
[quoted text clipped - 3 lines]
> 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?

Reply to this Message

Nicola - 13 Mar 2008 19:22 GMT

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.

> How do you know which request was the last one?
>
[quoted text clipped - 5 lines]
> > 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?

Reply to this Message

maceslin@gmail.com - 11 Mar 2008 11:36 GMT

> Hello,
>
[quoted text clipped - 3 lines]
> 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

Reply to this Message