Return string of missing numbers in a series

[Guest]

I have a numeric field in a table I am using to create a sequential report.
Because of how I have to generate the series, there are some missing numbers
towards the end of the list (i.e. 545 of 733, etc.). In order for me to
accurately generate a complete report I need to see those numbers (returned
as in a query) so I can fill in the original table. I am not as handy with
SQL (but trying to learn) and wasn't quite sure about the other post re: this
similar problem. I am running Access 2003 on Windows 2000 Pro.

 

[John Vinson]

On Wed, 19 Jul 2006 08:58:01 -0700, Dan Musselman <Dan

I have a numeric field in a table I am using to create a sequential report.
Because of how I have to generate the series, there are some missing numbers
towards the end of the list (i.e. 545 of 733, etc.). In order for me to
accurately generate a complete report I need to see those numbers (returned
as in a query) so I can fill in the original table. I am not as handy with
SQL (but trying to learn) and wasn't quite sure about the other post re: this
similar problem. I am running Access 2003 on Windows 2000 Pro.

The simplest way is to create a table with only one field, N,
containing all the numbers you expect (you can fill this table easily
by creating it in Excel using fill-down series, and import it into
Access). Use the Unmatched Query Wizard to find all the numbers in
this table which have no match in your table.

John W. Vinson[MVP]