Re: Monday-Sunday Date Range

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You've overthought the play, as

Between Now()-1 and Now()-7 would do.

As far as scheduling the query to run every sunday at 1:30am, Total Visual
Agent can help.

http://www.fmsinc.com/products/agent/index.html

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html


"Moochie169" <Moochie169@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AC99CD3D-2550-4557-A906-6DA976C1CDF0@xxxxxxxxxxxxxxxx
Hi,

I'm not very strong with Date functions especially calculating dates. But
I
have a report that I would like to automatically run every Monday morning
at
130AM. Many of my queries involved a date range which is the previous
Monday
to Sunday. I was wondering if someone can help me out so I can finally
sleep
early on Sundays.

I've look around and cannot find what I need. Here's what I have so far.

BeginDate: DateAdd("d",-7,Now())
EndDate: DateAdd("d",-1,Now())

My date criteria is
Between DateAdd("d",-7,Now()) And DateAdd("d",-1,Now())

I know this is not the most efficient way and that is also taking in the
time into consideration. But I'm running out of ideas.

Thanks for your help.






.

Relevant Pages

  • Re: Display all columns on a form that are shown in a drop-down bo
    ... Your scheduling table should ... be related to your StoreDectives table via some sort of unique Id ... use this query in your form. ... type in your employee name, last name first, your combo box will ...
    (microsoft.public.access.forms)
  • Re: OOC Scheduling - the numbers
    ... They were left out of the title picture because they play in the WAC. ... game by scheduling tougher OOC, so their poll positioning isn't soft. ... Team X and Y both play 8 conference and 4 OOC games. ...
    (rec.sport.football.college)
  • Re: Need Help Understanding How To Make This Work
    ... recordset consisting of a subset of the matching database record, ... The query on the table ... AgentName, in the record has a null value. ... In my program, I must first look to see if a record exists that matches the Firstname and Lastname of a client; then, I must look to see if an Agent is assigned to the client already. ...
    (comp.databases.ms-access)
  • Re: Change QueryTimeout
    ... change my query timeouts by updating the msdb database. ... I had no problems completing the replication query. ... Looking for a SQL Server replication book? ... I cannot get to agent properties because the subscribers are ...
    (microsoft.public.sqlserver.replication)
  • Re: Delete records with only Name and Date filled in
    ... there is a query attached to the form. ... Agent column in the query and the source for CallDate is the CallDate column ... It appears that you are calculating the values and assigning them to the ...
    (microsoft.public.access.formscoding)