Domain Aggregate Problems in Working with the QBE

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

I'm trying to build a query with three fields: newsID, newsTitle,
newsCategory, and newsDate. newsID is a simple AutoNumber field but is
essential for linking to other data. newsCategory is one of a series of
topical areas. What I need is a query that will return the maximum (most
recent) date for each topical area found in newsCategory. I can create a
query that groups by newsCategory with Max in newsDate, but the Query
Builder won't let me include newsID, newsTitle, or any other field that
isn't involved in a domain aggregate function. This has to be a common
problem, but for the life of me I can't seem to find a solution. Can anyone
provide me with a way to achieve what I need?

Larry
 
Back
Top