Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Missing record numbers.
Thanks jsteph, i created another table and then set up a variable to compare against the record number in the first table, if it existed i moved to the next record, or else i inserted the record into table 2, easy peasy. Thanks for the help.- thomsond
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Missing record numbers.
I am looking to create a table in Access which displays all of the numbers missing from a field in another table. For example, if a field name the_number had the following records: 1 2 4 5, i would like to return the value 3 in the new table. I am dealing with approx 90,000 records and...- thomsond
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Finding Missing Dates
Hello, this is a message to Golom. I have been reading your advice for this problem and i have something similar. I am attempting to locate missing numbers from a field. In one of your suggestion you mention the following: "Seems odd. A slightly altered version of this (finding missing...- thomsond
- Post #11
- Forum: Microsoft: Access Queries and JET SQL
