Displaying Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If [MatrixClass] = 1 Then
If [ExcptRate] = 0 Or IsNull([ExcptRate]) Then
[next_audit_date] = DateSerial(Year(Last_fye_date), _
Month([Last_fye_date]) + 36, Day
([Last_fye_date]))

How can I get the criteria to display on my report as well
as the results?

Last_fye_date 1/1/01 Next_audit_date 1/1/04 36 months
 
You pick the data up from where it exists and save it in a Control on the
Report. To give you a more precise answer, we need more precise information
Where is this information? How does the user specify it? Please clarify.

Larry Linson
Microsoft Access MVP
 
The last_fye_date was 12/31/02. The Matrix Class = 1 and
the Exception Rate = 0. I need to add 36 months to the
last_fye_date to determine the next_audit_date.

My report shows the last_fye_date of 12/31/02 (field from
table) and the next_audit_date 12/31/05 (field from
table). I also want the report to show the "36 Months"
that was determined by the code.

-----Original Message-----
You pick the data up from where it exists and save it in a Control on the
Report. To give you a more precise answer, we need more precise information
Where is this information? How does the user specify it? Please clarify.

Larry Linson
Microsoft Access MVP


If [MatrixClass] = 1 Then
If [ExcptRate] = 0 Or IsNull([ExcptRate]) Then
[next_audit_date] = DateSerial(Year(Last_fye_date), _
Month([Last_fye_date]) + 36, Day
([Last_fye_date]))

How can I get the criteria to display on my report as well
as the results?

Last_fye_date 1/1/01 Next_audit_date 1/1/04 36
Click to expand...
months


.
Click to expand...
 
Back
Top