Community
Showing results for 
Search instead for 
Do you mean 
Reply

Track missing sequential numbers ACT 2013

Bronze Elite Contributor
Posts: 1,430
Country: United_Kingdom

Track missing sequential numbers ACT 2013

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.

Copper Contributor
Posts: 16
Country: United States

Re: Track missing sequential numbers ACT 2013

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

Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: Track missing sequential numbers ACT 2013

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.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129