Track missing sequential numbers ACT 2013

[ch1p]

Looking for some help to get ACT to flag up missing account numbers.

Client puts in new records including account number. Wants to be able to see if there are missing account numbers and have this flagged up. They will all be sequential but may be put in out of order as inputted by a number of staff so a check at the time of creating the new record will not work. Any thoughts on how to tackle this in ACT?

Thanks in advance for any help.

[Tom Koller]

If I am understanding you correctly, here are a couple of suggestions.

In the Lookup Dialog Box, search for all records that "Do Not Contain Data."  You could also create a Dynamic Group that fires off the same Lookup criteria.  After the group is created you can easily activate it to view the records missing the data.  Hope this is what you want.

Regards,

Tom Koller - "The ACT Guy"

info@computingconnections.com

[Roy_Laudenslager]

Use the right click on the account number field and do a lookup first for does not contain data. That will find any records without an account number. Then to verify that no nymbers were duplicated or skipped. right click on the account number field and do the lookup for containc data. then in the list view click on the title for the account number field  to sort by the account numbers. check the account number of the first record in the list and then scroll to the last record. the account number there should be the account number of the first record plus the number of records in the lookup.