Need to filter form data by "this week"

[Guest]

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?

 

[Guest]

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.

 

[Guest]

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?

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

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?

 

[Guest]

Never mind - error between chair and keyboard....

Thank you Karl!

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?

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

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?