C
Chris
I have a field called Tbl_PIP.[Requires Specs] and a field called
Tbl_PIP_Phases.Date. I want to count the items in Tbl_PIP.[Requires Specs]
but only if those items happen to fall within the after 1/1/07 or prior to
todays date.
Example: Hotel ABC has 5 items due on 7/1/07 (These would go to
Tbl_PIP.[Requires Specs]. The hotel also has 5 items due on 12/1/07 (These
would also go to Tbl_PIP.[Requires Specs]. We have approved the 5 items due
on 7/1/07 (Tbl_PIP.[Specs Approved]) but not the 5 from December.
I want the report to look like this.
Items Due Specs Approved
%
Hotel ABC 5 5
100%
What I'm getting is...
Items Due Specs Approved
%
Hotel ABC 10 5
50%
I know this is kind of confusing but any help would be appreciated!
Tbl_PIP_Phases.Date. I want to count the items in Tbl_PIP.[Requires Specs]
but only if those items happen to fall within the after 1/1/07 or prior to
todays date.
Example: Hotel ABC has 5 items due on 7/1/07 (These would go to
Tbl_PIP.[Requires Specs]. The hotel also has 5 items due on 12/1/07 (These
would also go to Tbl_PIP.[Requires Specs]. We have approved the 5 items due
on 7/1/07 (Tbl_PIP.[Specs Approved]) but not the 5 from December.
I want the report to look like this.
Items Due Specs Approved
%
Hotel ABC 5 5
100%
What I'm getting is...
Items Due Specs Approved
%
Hotel ABC 10 5
50%
I know this is kind of confusing but any help would be appreciated!