J
Judy
Ok, here is the scenario...
I have a query is a make table query that feeds into a report as a
subreport...
The query is as such: criteria for only 2005, for all fields...
The fields are as such:
MMCurrent; MM1st Enrollment; Drill Current Date; Drill 1st enrollment;
Okay, what has happened is this...
In the Drill 1st enrollment it can have a date of 2005 (which I want) but in
the MMcurrent field, becuase it is tied to that particular "record" for that
person, it can also have a date of 1993 (I do not want). I want only to show
2005 field for a particular employee number.
Do I do a conditional statment "IF then" for the table?, query?, report? and
how do i accomplish somthing like this?
I have a query is a make table query that feeds into a report as a
subreport...
The query is as such: criteria for only 2005, for all fields...
The fields are as such:
MMCurrent; MM1st Enrollment; Drill Current Date; Drill 1st enrollment;
Okay, what has happened is this...
In the Drill 1st enrollment it can have a date of 2005 (which I want) but in
the MMcurrent field, becuase it is tied to that particular "record" for that
person, it can also have a date of 1993 (I do not want). I want only to show
2005 field for a particular employee number.
Do I do a conditional statment "IF then" for the table?, query?, report? and
how do i accomplish somthing like this?