K
Kay
This is a field in my query
Field Eligibilty Date: DateAdd("m",7,[Start Date])
Table
Total Expression
Sort
Show Yes
Criteria
Format mm/yy
that returns the following example correctly:
Start Date Eligibilty Date
01/01/2008 07/08
But what I dont know how to set the criteria to pull only the current months
records of eligibilty. I have tried adding two additional fields that looked
like below,
Field month([eligibilty date])
year([eligibilty date])
Table
Total Expression
Expression
Sort
Show Yes Yes
Criteria Month(Now())
Year(Now())
However all I get is a prompt to enter the paremater value of "eligibilty
date"
My ultimate goal is to have a form that displays a count of how many records
contain the current mm/yy in the "elgibilty date" field.
Anyone have any ideas?
Thanks in advance
Kay
Field Eligibilty Date: DateAdd("m",7,[Start Date])
Table
Total Expression
Sort
Show Yes
Criteria
Format mm/yy
that returns the following example correctly:
Start Date Eligibilty Date
01/01/2008 07/08
But what I dont know how to set the criteria to pull only the current months
records of eligibilty. I have tried adding two additional fields that looked
like below,
Field month([eligibilty date])
year([eligibilty date])
Table
Total Expression
Expression
Sort
Show Yes Yes
Criteria Month(Now())
Year(Now())
However all I get is a prompt to enter the paremater value of "eligibilty
date"
My ultimate goal is to have a form that displays a count of how many records
contain the current mm/yy in the "elgibilty date" field.
Anyone have any ideas?
Thanks in advance
Kay