Need to filter form data by "this week"

Might need to do this with VBA, I know...I'm wanting a subform that will show 
a group of records with a "due date" of this week (as defined by access) - 
that will automatically update each week without user input.  

Anyone have a simple routine for this?
0
Utf
6/15/2007 8:56:01 PM
access.forms 6864 articles. 2 followers. Follow

3 Replies
564 Views

Similar Articles

[PageSpeed] 24

In the design view of your query add a field like this --
     Expr1: Format([date of inspection],"yyyyww")
Use the name of your date field.
In the criteria row below that fields enter this ---
    <=Format(Date(),"yyyyww")

This will give you all due this week or before.  You might want to add 
additional criteria to not pull records already completed.
-- 
KARL DEWEY
Build a little - Test a little


"physics_gal" wrote:

> Might need to do this with VBA, I know...I'm wanting a subform that will show 
> a group of records with a "due date" of this week (as defined by access) - 
> that will automatically update each week without user input.  
> 
> Anyone have a simple routine for this?
0
Utf
6/15/2007 9:17:10 PM
That works to filter it, but I lose the ability to see the actual date.  Is 
there a way to "copy" the original date, in normal format?


"KARL DEWEY" wrote:

> In the design view of your query add a field like this --
>      Expr1: Format([date of inspection],"yyyyww")
> Use the name of your date field.
> In the criteria row below that fields enter this ---
>     <=Format(Date(),"yyyyww")
> 
> This will give you all due this week or before.  You might want to add 
> additional criteria to not pull records already completed.
> -- 
> KARL DEWEY
> Build a little - Test a little
> 
> 
> "physics_gal" wrote:
> 
> > Might need to do this with VBA, I know...I'm wanting a subform that will show 
> > a group of records with a "due date" of this week (as defined by access) - 
> > that will automatically update each week without user input.  
> > 
> > Anyone have a simple routine for this?
0
Utf
6/15/2007 9:24:00 PM
Never mind - error between chair and keyboard....

Thank you Karl!

"physics_gal" wrote:

> That works to filter it, but I lose the ability to see the actual date.  Is 
> there a way to "copy" the original date, in normal format?
> 
> 
> "KARL DEWEY" wrote:
> 
> > In the design view of your query add a field like this --
> >      Expr1: Format([date of inspection],"yyyyww")
> > Use the name of your date field.
> > In the criteria row below that fields enter this ---
> >     <=Format(Date(),"yyyyww")
> > 
> > This will give you all due this week or before.  You might want to add 
> > additional criteria to not pull records already completed.
> > -- 
> > KARL DEWEY
> > Build a little - Test a little
> > 
> > 
> > "physics_gal" wrote:
> > 
> > > Might need to do this with VBA, I know...I'm wanting a subform that will show 
> > > a group of records with a "due date" of this week (as defined by access) - 
> > > that will automatically update each week without user input.  
> > > 
> > > Anyone have a simple routine for this?
0
Utf
6/15/2007 9:29:00 PM
Reply:

Similar Artilces:

Need to filter form data by "this week"
Might need to do this with VBA, I know...I'm wanting a subform that will show a group of records with a "due date" of this week (as defined by access) - that will automatically update each week without user input. Anyone have a simple routine for this? In the design view of your query add a field like this -- Expr1: Format([date of inspection],"yyyyww") Use the name of your date field. In the criteria row below that fields enter this --- <=Format(Date(),"yyyyww") This will give you all due this week or before. You might want to add additio...

The Newest Special Offers/Discount/Coupons This Week
Save 20% on powerspeaK12 Online Foreign Language Programs for the Summer http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1122&forum=13&post_id=1166#forumpost1166 Luxury Kitchen & Bathroom Fixtures http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1155&forum=45&post_id=1199#forumpost1199 Award Winning Web Hosting http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1150&forum=79&post_id=1194#forumpost1194 Great Deals on Ink & Toner http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1126&forum=42&pos...

The Newest Special Offers/Discount/Coupons This Week
Save 20% on powerspeaK12 Online Foreign Language Programs for the Summer http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1122&forum=13&post_id=1166#forumpost1166 Luxury Kitchen & Bathroom Fixtures http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1155&forum=45&post_id=1199#forumpost1199 Award Winning Web Hosting http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1150&forum=79&post_id=1194#forumpost1194 Great Deals on Ink & Toner http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1126&forum=42&pos...

Redmond Bound
Hopefully JoAnn, Ed, David A, Mary, Don and company have things under control this week, through Friday. David Bartosik and I will be in the belly of the 800lb. gorilla flying black helicopters around pretending to be King Kong this week. We may or may not be able to pop in to check up on everyone, otherwise, see you in a weekish. And before you ask, no, we will not slap Bill Gates around for ya :-) -- Brian Kvalheim Microsoft Publisher MVP http://www.mvps.org/publisher This posting is provided "AS IS" with no warranties, and confers no rights. Have a safe trip and behave yo...

filtering dates within this week
I have a series of dates. How can i filter dates that are within this week? thanks I would add another column to represent the year and week number. Then filter on that. Excel has its own =weeknum() function (requires installation of the analysis toolpak in xl2003 and below). But week numbers mean different things to different people/groups/organizations. I'd start with Ron de Bruin's site if excel's =weeknum() isn't sufficient: http://www.rondebruin.nl/weeknumber.htm http://www.rondebruin.nl/isodate.htm Lynn wrote: > > I have a series of dates. How can i filter d...

Dramatically Increase your Sales/Visitors this week.
Dear Sir/Madam, My name is Bruce SMART. I'm in the team of Stephan DUCHARME, The Freeadguru. Best-selling author and Internet self-made Multi-Millionaire - Getting up to 1.2 Million hits a month. I can help you get a boost of visitors and sales THIS WEEK. Please respond quickly. Regards Bruce SMART --- MAF Anti-Spam ID: 20050916185548U6g4SxD2 ...

select this weeks data only
I have a worksheet thats created from a data import from an accounts package I'd like to sum the values of sales for this week only starting Monday and the SUM result would grow to Friday before returning to zero next monday morning the worksheet has multiple entries for each day, in date format dd/mm/yyyy at the moment. I'm managing to count number of sales for the month per sales rep, with the formula below but seem to struggle for current week only reporting, (plus I need SUM of Sales as well as the COUNT) =COUNT(IF((data!FU$2:FU$6474="salesrep1")*(MONTH(data!M$2:M$64...

How Prevent Zero Data From Later This Week From Getting Graphed?
- My X-axis data is a weekly date. - My Y-axis data is a number entered weekly. - One day after the weekly date when the data number is entered, the chart line drops off to zero, presumably because there is no data number entered and one won't be until the next weekly data entry date. How can I prevent this line from dropping off to zero? xl2007: Right click on chart. Then click Select Data, click on Hidden and empty cells (bottom left of dialog box) and and check box as to how to handle empty cells. xl2002: Click on chart to select it. Select Tools->Options->chart tab and ...

Count Records for this week, this month, this quarter, this year
Hello, I am using the code-- =DCount("[ClaimID]","tblClaims","DateValue([DateCreated])=Date()") --to count the number of record created today. I would like to use a similar code to count the number of record created: 1) This week 2) This Month 3) This Quarter 4) This Year When I say “this”, I mean the current week, month, Quarter and Year based on NOW. For example, if I have 5 record for December 2009 and 6 records for December 2008, since we are in 2009 the total for “This Month” will be 5 (not 5 + 6 = 11). Also, my record CreatedDate has a dat...

OT: This week I will mostly becoming a.....
"Microsoft Business Solutions (MS CRM) Applications Professional" Pass mark required 80%....and guess what my mark was? Tough exams, wonder what the install & customisation courses are like as I know one of our guys has failed twice already, with fairly close scores.I probably wouldnt stand a chance, but I havent done the course. Any of you lot tried the course and exams what do you make of it. I flunked the product side but got away with it because of the percentage breakdown. Tone On Thu, 20 May 2004 11:46:39 +0100, Tone wrote: > "Microsoft Business Solutions (...

auto-update cells with this week/last week's totals?
Hi there! I have 3 cells - C2, D2 & E2. C2 contains the formula =SUM(C1528:C1534). D2 contains the formula =SUM(D1528:D1534). E2 contains the formul =IF(ISERROR(AVERAGE(E1528:E1534)),"PACE!",AVERAGE(E1528:E1534)) C2 shows the total number of miles I have run from Monday of th current week to Sunday inclusive. D2 shows the total hours I have run over the same period of time. E2 shows the average pace I've run at, again over the same period o time. (I added the ISERROR function for neatness as I had to kee amending the column width when I get the DIV0 error). C3, ...

What did you learn this week?
I tell my grandniece she needs to learn somehting new every day.........What did you learn about Publisher this week? -- The problem with sitting on your laurels is that eventually you are sitting on dead branches. JoAnn One of my grandchildren was taken to an Observatory. Later he told his mother "Grandad said You should learn some thing new each day and I think I have learnt enough for 2 weeks". -- Wot's Your Real Problem? John G. "JoAnn Amerson" <jl_amerson@hotmail.com> wrote in message news:%23UHHVW1QDHA.3664@tk2msftngp13.phx.gbl... > I tell my ...

RC this week?
With Symantec's lauch of Backup Exec 2010 and Netbackup 7, both supporting Exchange 2010, I was really hoping to hear that a DPM RC would be released today as well. Any comments on when we will hear the announcement? ---------------------- Brian Kronberg I sure hope so, I know of several clients who are looking to move to this! "Brian Kronberg" wrote: > With Symantec's lauch of Backup Exec 2010 and Netbackup 7, both supporting > Exchange 2010, I was really hoping to hear that a DPM RC would be released > today as well. Any comments on when we ...

New beta THIS week.
Many sources cite that we will finally see a new Live Essentials beta on Thursday. It has been a long time coming. I hope it impresses. Useful news, if true. We may see how many bugs have been fixed. But trying to run a beta on a non-test-based, consumer system is a risky maneuver at best. Nancy "osu9400" <osu9400@hotmail.com> wrote in message news:uGX7gPhELHA.1868@TK2MSFTNGP05.phx.gbl... > Many sources cite that we will finally see a new Live Essentials beta on > Thursday. It has been a long time coming. I hope it impresses. There h...

New View
I'd like to create a new account view exactly like the New Leads-This week view. How do you tell CRM the data range or is this a view that can be copied from leads to accounts? when you create the new account view you can click the edit filter criteria button and choose the fields you want to filter on. If you choose the field called createdon, you can choose a condition called Last Week or This Week etc. hope this helps -- John O'Donnell Microsoft CRM MVP "debbie" <debbie@discussions.microsoft.com> wrote in message news:2d1eb01c46ab1$71747630$a601280a@phx.gb...

The Special Coupons and Offers This Week
A virtual PBX system with voicemail and Internet Fax. Try it free today. http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1136&forum=42 A Special $10 off "moo"pon -- Just for you! http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1125&forum=79 Dictate to your Mac http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1282&forum=13 10% off Nuance Dragon Naturally Speaking Preferred! Use coupon code 10DNS08 http://www.sogiant.idv.tw/modules/tinyd0/index.php?id=69 RingCentral Online - Free Trial plus 10% Off http://www.sogiant.idv....

The Special Coupons and Offers This Week
A virtual PBX system with voicemail and Internet Fax. Try it free today. http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1136&forum=42 A Special $10 off "moo"pon -- Just for you! http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1125&forum=79 Dictate to your Mac http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1282&forum=13 10% off Nuance Dragon Naturally Speaking Preferred! Use coupon code 10DNS08 http://www.sogiant.idv.tw/modules/tinyd0/index.php?id=69 RingCentral Online - Free Trial plus 10% Off http://www.sogiant.idv....

What I've learned about Publisher this week...
Merging a mailing list from Excel into Word and then into Publisher is NOT a fun task. Formatting is lost or boogered up. I've had to do things twice....and sometimes three times. I'm on my fourth pass over the list of just under 700 students to get the formatting the way I want it so that when the inevitable changes are emailed to me, I can just pop them in with little work. (Ha ha ha ha! Like THAT will really happen.) <sigh> Back to work -- JoAnn Paules MVP Microsoft [Publisher] I did the same thing when I was composing a directory for a local chamber of commerc...

This week's investment outlook
Last week's currency trading market affected by the US subprime mortgage crisis. The Dollar become persistent at last week's forex trading market. This week's currency trading market will focus on the interest rate meeting of Fed, here is the outlook for this week's currency trading market More http://www.forexmarketwatcher.com ...

New Auto Articles this Week
New Auto Articles this Week - freeinformationwebsite.com http://www.freeinformationwebsite.com/autos.html Honda Distributor Cap for an Efficient Ignition http://www.freeinformationwebsite.com/Articles/31.html Time it Right with Honda Distributor Rotors http://www.freeinformationwebsite.com/articles/32.html Emergency Supplies Everyone Needs Inside Their Vehicle http://www.freeinformationwebsite.com/articles/33.html Chivalry is a Honda Door Handle http://www.freeinformationwebsite.com/articles/34.html Safeguarding Your Honda http://www.freeinformationwebsite.com/articles/35.html Reducing E...

The Newest Special Offers/Discount/Coupons This Week
Save 20% on powerspeaK12 Online Foreign Language Programs for the Summer http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1122&forum=13&post_id=1166#forumpost1166 Luxury Kitchen & Bathroom Fixtures http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1155&forum=45&post_id=1199#forumpost1199 Award Winning Web Hosting http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1150&forum=79&post_id=1194#forumpost1194 Great Deals on Ink & Toner http://www.sogiant.idv.tw/modules/newbb/viewtopic.php?topic_id=1126&forum=42&pos...

Ask a MSFT expert about Outlook and CRM--this week!
Hi all, Welcome to the second MBS Community discussion held directly in the Microsoft CRM newsgroup. During the week of October 11, Microsoft CRM Program Manager Ilana Smith will answer questions -- right in this discussion thread -- about using Microsoft CRM Sales for Outlook client. For those of you who haven't met Ilana in the CRM newsgroup before, I'd like to introduce her now: Ilana has been with Microsoft for almost 5 years. Before moving to the Microsoft CRM product team, she worked at Microsoft Australia as a Technical Specialist and in Redmond, Washington, USA, in...

Ask a MSFT Expert About CRM Security--This Week
Hello all, Welcome to the first Business Solutions Community discussion held directly in the Microsoft CRM newsgroup. During the week of October 4th, Tanim Ahmed, a Technical Lead on the Microsoft CRM Support Team, will answer questions about troubleshooting CRM security -- right in this newsgroup thread. How is this different than any other week in the newsgroup? While product support experts like Tanim may visit the newsgroup during their workweek to answer customer and partner questions, they don't necessarily solicit questions on a particular topic as we’re doing here. Duri...

Count Records for this week, this month, this quarter and this yea
Hello, I am using the code-- =DCount("[ClaimID]","tblClaims","DateValue([DateCreated])=Date()") --to count the number of record created today. I would like to use a similar code to count the number of record created: 1) This week 2) This Month 3) This Quarter 4) This Year When I say “this”, I mean the current week, month, Quarter and Year based on NOW. For example, if I have 5 record for December 2009 and 6 records for December 2008, since we are in 2009 the total for “This Month” will be 5 (not 5 + 6 = 11). Also, my Record Created date had a da...

i haev not used excel much this weeks, but it has just started to play up.
it seems to be having a problem. I start excel as normal from the start menu and then Microsoft Excel, then I click a box to start typing, if after clicking a box, and I move the mouse in any direction it starts to select boxes. like the mouse button is already held down, but it is not, I have tried another mouse and also tried the keyboard short cuts and had the mouse unplugged too, when I have restarted the pc to make sure it was not anything to do with the mouse. has anyone else had this and fixed it,? if so how did you fix it, thanks in advance for any help that you are able to give ...