Stumped - How to report most recent line/row?

S

seve

Can't locate an answer, so I appreciate any assistance.

I sort a database of sales orders by sales rep, clinic and date of
service.

I'd like to show the latest date of service for each clinic, without
having to print off 100's of pages of data.

In other words, I want to be able to show sales reps the last order
date for their clinics.


Any help?

Many thanks,

Steve
 
G

gjcase

How about a bout a Pivot table with the clinic on the left axis, the
sales reps acros the top, and MAX of the dates in the field?

---GJC
 
G

gjcase

Glad to help, I owe the folks on this forum for the help I've receive
in the past...

---GJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add Sales Goals to Sales Report in Pivot Table 1
macro to delete lines based on a value - Repost 2
how do i select the most recent value in a row 3
Need a bit of help 2
How to Copy Field Values to Group Subtotals row 1
Report query for most recent date 2
DLookUp criteria help - involved one! 1
DLookUp Field Criteria - HELP!!!! 1

Top