Using 'Max' in a query

[Guest]

Hello,
When I use 'Max' in a query in a date field. I do not get the correct
records for the fields associated with the date field. I do however get the
correct 'Max' date.
Why is this happening?
Example field names:
PayeeDate
Activity
HoursSpent
AmountPaid

 

[Marshall Barton]

When I use 'Max' in a query in a date field. I do not get the correct
records for the fields associated with the date field. I do however get the
correct 'Max' date.
Why is this happening?
Example field names:
PayeeDate
Activity
HoursSpent
AmountPaid

Hard to tell without seeing the query.

An aggregate function is normally used in a Totals type
(Group By) query. The other fields in the query must be
specified as Group By, which means they will all be the
same. So, how could they be wrong?

Maybe(?) you want to sue a SELECT TOP 1 type query instead
of a Totals query??

 

[[MVP] S.Clark]

Read this: http://www.mvps.org/access/queries/qry0020.htm

Feel free to ask any further questions about it.

 

[Chris2]

Hello,
When I use 'Max' in a query in a date field. I do not get the correct
records for the fields associated with the date field. I do however get the
correct 'Max' date.
Why is this happening?
Example field names:
PayeeDate
Activity
HoursSpent
AmountPaid

D'Angelia,

You wrote: "When I use 'Max' in a query in a date field. I do not get
the correct records for the fields associated with the date field."

And: "I do however get the correct 'Max' date."

Please forgive me, but I am not sure how that goes together.

"I do not get the correct records" and "I do however get the correct
'Max' date" seem to be opposite statements.


Sincerely,

Chris O.

 

[Guest]

Chris2,
I went to mvps.or/access and it worked.

Thanks again...

 

[Guest]

S.Clark,

I went to mvps.org/access and it worked. Thanks, A-million!!!!

I do however have a continuation to this situation.
I'm trying to get a YTD total for each record in the query.
Should I post it separately?
--
Thanks
D''''Angelia

Read this: http://www.mvps.org/access/queries/qry0020.htm

Feel free to ask any further questions about it.