Hi Kathleen,
Welcome!
make a textbox with this ControlSource:
=DLookup("[CashLeft]","[Tablename]","[SalesDate]=#" & Date()-1 & "#")
WHERE
CashLeft is the field with cash left at the end of the day
Tablename is the name of the table
SalesDate is the field with your date of sale
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: KTT47
How hard it is to learn. How easy it is to forget!
The system I inherited is mostly stable right now, so I have not done any coding in a while. Now I want to make a change and I cannot for the life of me figure out how to approach it.
I have a summary form that is filled out for each day. One of the fields is the cash left at the end of the day. Actually, that is a calculated field but the record contains the data to calculate it. What I want to do is show the previous days cash on today's form. The key is the date. So when the date, for example, is December 2, I want to see the cash that was left in the drawer on December 1.
Thanks for any suggestions.
Kathleen in Maryland
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar