Forum Discussion
Tony2021
Jan 05, 2022Steel Contributor
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...
- Jan 06, 2022
you maybe right, see Query1 (also query qryLC_MaxDate).
arnel_gp
Jan 06, 2022Steel Contributor
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.