Re: [MS_AccessPros] Re: Need help with query for form

 

thank you, Kathleen :) ... and you are welcome :)

Happy New Year
warm regards,
Crystal

* have an awesome day :)

________________________________
From: KTT47


Thanks, Crytal and happy birthday yesterday.  I am still working on getting this to work exactly the way I need it to, but you have given me the framework I needed. 

Thanks again.
Kathleen
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> 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
>
>

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 5

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___