Forum Discussion
Balance with Max
Hello Experts, I have a simple query and I need to show the tblLetterOfCredit.[Balance] based on the MAX of qryBalLC.ID. I have been fiddling around with it for awhile and I guess my approach is...
you maybe right, see Query1 (also query qryLC_MaxDate).
you don't want to use the autonumber ID on the max() function.
autonumber can Guarantee the Uniqueness of record, but not it's Sequence.
it can even have Negative value and what else.
so your best field to use Max is on the Date field.
autonumber can Guarantee the Uniqueness of record, but not it's Sequence.
it can even have Negative value and what else.
so your best field to use Max is on the Date field.
