Help with field in an Access form?

[Brenda]

I have created a teller database in MS Access using drawer #1 and drawer #2.
I would like to click a button within the balancesheet (access form) and have
it bring up the ending cash from the last time that specific drawer was used.
How can I do this?

 

[Sharkbyte]

Brenda:

Without knowing more about your db structure, it is a little difficult.
However, it could be done with something like:

DLookup("EndingBalance", "tblCashDrawers", "DrawerNumber = <DrawerNumber>
and Date = DMax("UsedDate", "tblCashDrawers", "DrawerNumber = <DrawerNumber>")

Good luck.

Sharkbyte