Checking for missing cheques

[Chesne]

Can anyone help with some code which will enable me to enter the first
cheque number and the last cheque number and to determine if there are
any cheque missing from the sequence?

Any help would be greatly appreciated. TIA - Chesne

[PC Datasheet]

Re: Checking for missing cheques

Create a numbers table with one field named MissingCheckNum . Fill the table
with the numbers 1 to the highest possible check number. Create a a new
query and using the Unmatched Query Wizard. Follow the directions to find
the MissingCheckNum s in the numbers table that are not in the table with the
cheque number field. Set the criteria:
Between FirstChequeNumb er And LastChequeNumbe r

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdata sheet.com

https://www.pcdatasheet.com

"Chesne" <ashfield@parad ise.net.nz> wrote in message
news:1110835956 .045776.156280@ z14g2000cwz.goo glegroups.com.. .[color=blue]
> Can anyone help with some code which will enable me to enter the first
> cheque number and the last cheque number and to determine if there are
> any cheque missing from the sequence?
>
> Any help would be greatly appreciated. TIA - Chesne
>[/color]

[Douglas J. Steele]

Re: Checking for missing cheques

Check my April, 2004 Access Answers column for Pinnacle Publication's Smart
Access.

You can get the column (and accompanying database) for free at

http://www.accessmvp.com/djsteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP

http://I.Am/DougSteele

(no e-mails, please!)



"Chesne" <ashfield@parad ise.net.nz> wrote in message
news:1110835956 .045776.156280@ z14g2000cwz.goo glegroups.com.. .[color=blue]
> Can anyone help with some code which will enable me to enter the first
> cheque number and the last cheque number and to determine if there are
> any cheque missing from the sequence?
>
> Any help would be greatly appreciated. TIA - Chesne
>[/color]