Query to check for missing numbers

  • Thread starter Thread starter Gale Coleman
  • Start date Start date
G

Gale Coleman

Hello all,

We are using Access 2000 on Windows 2000 professional. I have a database
table that I need to look for missing numbers. Our records are put into the
table with a number like so: 04-1006999 or 04E-1006999. I want to be able
to create a query or report or something to check for missing numbers.

Can someone point me in the right direction?

Thanks,

Gale
 
hi,
Write a select query selecting all the field that you want.
in the cirteria pane of the number field enter is null
the query will display all records that have a null number
field.
regards
Frank
 
I am trying to find numbers that are missing from the sequence.

For example.

I have 04-1006999 then 04-1007000 and want to know if 04-1007001 is missing
from the sequence.

The other problem I have is that some of the numbers start with 04- and some
of them start with 04E-. I want to trim the "E" out and go from there.

Gale
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trim String 7
Trim Query and Report to Show Missing numbers 8
Concatenate Date and Number field for Append Query 0
Question About Missing Data 3
Unmatch query 7
check out a record 1
How to check for missing required daily entries (records) 10
Query by DOB 1

Back
Top