Lawrence Mrazek
lmrazek at lcm-res.com
Thu Jul 8 08:55:54 CDT 2010
Hi folks: I'd like to bind a listbox to use a query that returns the top record for each item in a group, where the group is sorted by date descending. Basically, I have: Company MaterialName PriceDate Basically, would like to group by Company, MaterialName, and sort desc by PriceDate ... I only want to see the most recent record for each Company/Material Name combination. Each Company / Material combo could have a different date, so I can't limit it that way. Can I do this with a query? Another method? Thanks in advance! Larry Mrazek ph. 314-496-1645 lmrazek at lcm-res.com http://www.lcm-res.com