

Specialist
2018-10-31
07:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Autogenerate numbers between 2 values
Hi folks,
I need to generate field / table with sequential numbers from X to Y (where X and Y are two variables such as X=666 and Y=2121) .
What's the easiest way to do this?
My end goal is to join another table to this so I can easily see where a record is missing, as I'll have data with records from 666 to 2121 for example but some will be missing... by joining the two I'll be easily able to filter the "missing" records so I can go away and look as to why they are not there.
- Tags:
- autogenerate
2,086 Views
1 Solution
Accepted Solutions

Partner - Specialist II
2018-10-31
07:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Load
RecNo() + $(X) -1 as field
AutoGenerate ($(Y) - $(X) +1)
;
Help users find answers! Don't forget to mark a solution that worked for you!
1 Reply

Partner - Specialist II
2018-10-31
07:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Load
RecNo() + $(X) -1 as field
AutoGenerate ($(Y) - $(X) +1)
;
Help users find answers! Don't forget to mark a solution that worked for you!
