Checking a series of numbers

A

Aldo

When running a report from a workorder database,I would like to set a format
to change the font of a number if the the number before it is less than that
field -1. Just to help point out a missing workorder number. I'm sure there
is an eay way to do it, but I do not know it.

Thanks,
Aldo
 
M

Marshall Barton

Aldo said:
When running a report from a workorder database,I would like to set a format
to change the font of a number if the number before it is less than that
field -1. Just to help point out a missing workorder number. I'm sure there
is an eay way to do it, but I do not know it.
Click to expand...

The problem here is figuring out what the "previous" record
is. If you have the data in a particular sort order, then
you might be able to look up the "previous" value by using
something like this in the section's Format event procedure:

If numberfield -1 > DMax("numberfield", "thetable", _
"numberfield < " & Me.numberfield) Then
Me.numberfield.FontItalic = True
Else
Me.numberfield.FontItalic = False
End If
 
Top