Re: date expression to bring up a weeks worth of records
From: "kingston via AccessMonster.com" <u27511@uwe>
Date: Mon, 27 Nov 2006 17:45:51 GMT
Use a Between criteria with the function Weekday():
Between [InputDate]-Weekday([InputDate])+1 AND [InputDate]+7-Weekday(
[InputDate])
Chris wrote:
i have my new data base built but for the love of god can i get the
expression right this.
in my query i need, when prompted it asks for a date, and when i put in
21/11/06, i want it to bring up all records for that week( monday to sunday).
can anyone 1 help plz.
Re: Sub Query Problem ..."Chris" wrote in message ... > I've seen in the Access online help that you can use a sub query as criteria> for another, but I fail to get this working, always getting an error. ... This table has 4 records and these records> needs to be used as the criteria to filter the info of a query of another> bigger table. ... (microsoft.public.access.queries)
Re: Sub Query Problem ...Chris... On the Criteria line under the ... >> I've seen in the Access online help that you can use a sub query as ... (microsoft.public.access.queries)
RE: IIF Expression with Between Dates criteria ..."Chris" wrote: ...query to return records that are scheduled in that time frame,... I change the criteria to just "Between DateAnd Date+30" it does show the ... (microsoft.public.access.queries)
RE: Reports ... I built the Form and named it form1 for now & entered ... In same criteria box as between and ... I have a Query also that has the fields to contain the info. ... Thanks chris, I am close Thanks to you ... (microsoft.public.access.reports)
Re: using a form with combo box to input criteria ...Candia Computer Consulting - Candia NH ... When you removed the criteria,... Then your criteria in the query would be... ... query behind your main report.... (microsoft.public.access.forms)
