[MS_AccessPros] Re: Need help with query for form

 

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
>
>

__._,_.___

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

Messages in this topic (4)

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

.

__,_._,___