Need to filter form data by "this week"

P

physics_gal

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?
 
K

KARL DEWEY

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.
 
P

physics_gal

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 said:
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 said:
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?
Click to expand...
Click to expand...
 
P

physics_gal

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

Thank you Karl!

physics_gal said:
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 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Top