Rolling Time Interval, and xx/xx/xx to day of week

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

Hello,

I am looking to get two questions answered if someone would be so kind
:)

1. I am looking to generate a querry that would pull up X events that
happen within any (rolling time period) Y month period Z amounts of
times. How would I create that querry?

ex. I have a checkbox on a form, and I want to know if that check box
was true 4 or more times in any rolling previous (to current) 3 month
period.

2. Is there a function that will take a date such as 08/21/06 and
convert it to that particular day of the week (Monday)? I know there
is, but can't seem to find it.

Many thanks for your help in advance,
Charles
 
Charles

Remember that queries run against tables, not forms. Are you saying that
you have a table that has multiple Yes/No fields? If so, take a moment to
review your data structure -- it might be easier to do what you want if your
data was well-normalized.

You can count the number of Yes/No fields that hold a Yes by adding them
(and taking the absolute value).

You can set a parameter of Date()-120 (or use the DateDiff() function) to
set your date limit.

You can use a format of "dddd" on your date to get the day-of-week.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Jeff said:
Charles

Remember that queries run against tables, not forms. Are you saying that
you have a table that has multiple Yes/No fields?
Click to expand...

No... it is a "Call in" Table. And the check box is for "unscheduled".
Only one check box.

So what I am looking for is the ability to find any given time period
(without knowing a reference date) where there were 4 or more
unscheduled call in's for any particular person in a given time frame
such as a rolling quarter year etc..


If so, take a moment to
 
Back
Top