Displaying Criteria

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

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]))
 
Generally, in Access, when we speak of Criteria, we are speaking about the
WHERE clause of a Query -- that doesn't seem to be the case in your
question. You show some code, then ask a question, but I don't understand
how one relates to the other. Could you 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 and the
next_audit_date 12/31/05. I also want the report to
show "36 Months"

-----Original Message-----
Generally, in Access, when we speak of Criteria, we are speaking about the
WHERE clause of a Query -- that doesn't seem to be the case in your
question. You show some code, then ask a question, but I don't understand
how one relates to the other. Could you 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