Hi, and thank you for the amazing resources here at computer learning zone. You have a great balance between free and paid-for. Any ideas how to use max date properly. If i use max date and then 'group by' all the other fields, if any fields differ it splits them back up. We've build an audit database for craft staff (carpenters), there may be several audits per person but we need a form that shows the very last audit per person only, but still keep the other fields in the record. I hope that makes sense
Kevin Yip
@Reply 3 years ago
You can't add other fields in that manner. An aggregate query can only contain group-by fields and aggregate fields. If you force other fields in there, it will affect the result, as you saw. If you need to add additional fields without affecting the aggregates, one way to do it is to create a second query based on the aggregate query.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
