Re:query to pull up all jobs due on WEd. for example
- From: "Michael White"<BigBull@xxxxxxxxxxxxx>
- Date: Thu, 12 Jul 2007 14:36:28 -0500
It seems to me you should be using a 3 letter identification for day of the
week to distinguish between Tuesday, Thursday, Saturday and Sunday.
Here is my solution:
Three lettered day:
Criteria [field] = CStr(Format(Date(),"ddd"))
1 Lettered day
Left(CStr(Format(Date(),"ddd")),1)
Either one will work for criteria on an Access Database, if you are using
SQL server, then you need to do something completely different.
.
- Prev by Date: Restricting Access to Controls Based on Information from other Controls
- Next by Date: Re: Checkbox tally on Continuous Forms
- Previous by thread: Restricting Access to Controls Based on Information from other Controls
- Next by thread: Re: Design view and form view text is different??
- Index(es):