Issues with query results

[bchi99]

I have a query that groups and counts certain emails by a matter number. In my query I have selected a series of fields and one of the fields is received date in which i'd like the query to return the date of the oldest/first email as seen in the screen shot.






Again, I want to show the oldest date of one of the grouped records but in the results it is showing me 11/12/2014 11:39 PM which isn't the oldest.



Here are the email dates in this group of 3:




Shouldn't it show 11/12/2014 10:32 AM as the first received email and that date should be in the results???

Anyone else run into this?

[burrina]

Take a look at this link, it may help. https://support.office.com/en-us/art...rs=en-US&ad=US

[bchi99]

will that apply within this query? eventually this query will be a report.

[burrina]

If it gets the results you want, then no problem, adjust as needed or else create a new query/report or change the record source dynamically!

[kagoodwin13]

You've also got Total of First on your ID field as well. Access may be sorting by ID rather than by Received.

You might be able to break up the steps into two queries, with the second query referencing the first. See the series of screenshots in the link below. I put the design view, then the datasheet view, for both queries. I think that is the output you are looking for. If not, let us know, and we can help you further.

https://imgur.com/a/VhWEP

[TechRW]

Could use the query properties box to have the query display only the first or last as well

[June7]

Don't use First(), use Min().

First() and Last() not always reliable for desired output. Usually Min() and Max() are what is needed.

[bchi99]

thanks min max worked.