Limiting Query Results

[benbanyas]

I am trying to run a query that has these columns

"Catalog Name" "Date Entered" "Session Number" "Item number"

The Item Number is specific to the session number (i.e. Session 3 Item 1,
Session 2 Item 2) and there is one session per catalog per day. I want the
query to return the most recent date an item was recorded for each catalog,
the Session Number and Item Number for that session. All of these columns
have duplicates so just using the "Max" total won't work. The closest I can
get is by using Max on "Date Entered", sorting Descending on "Date Entered",
and using Max on "Item Number." The problem is this returns the Max Item
Number for each date's session for the catalogs and not just the most recent
date data was entered.

Thanks for any help you can provide!

-Ben Banyas

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "MaxQueryProblem.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[benbanyas]

Thanks for the help but my company limits my internet Access so I can't view
your sight. Could you (or anyone else) offer me any more help in a post?

Also, to clarify, each catalog will only have one session in a given date,
but every catalog will not have sessions for every date.

Thanks Roger and hopefully you can help me out some more despite my Internet
restrictions!