Alert user when number is skipped

[itsuit]

I use an Access 2000 report to create checks based on information in an external ODBC database. I'd like to have the user alerted if a check number in the report is skipped (the check number comes from a field in the external view and is stored as a number).

Any help is appreciated.

 

[PWise]

Create A numbers table
1 field digitid
with numbers from 1 to .......

create a query AllChecknums

Select digitid
from numbers
inner join (Select min(Checkno)mincheckno,max (checkno)     maxcheckno
from ExternalTable)
on digitid between mincheckno and maxcheckno

your recordsource on the report should be

Select digitid from AllChecknums
left join ExternalTable
on ExternalTable.checknum = AllChecknums.digitid

on the report add text box with this control source

=nz(ExternalTable.checknum,AllChecknums.digitid)+ " is missing in ExternalTable"