How can I get Access to flag for a missing number in a sequence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with Access 2000. I am a student and the assignment is to
identify missing invoices. I cannot readily find the proper method.
 
On Mon, 24 Oct 2005 10:26:12 -0700, "Shelby A" <Shelby
I am working with Access 2000. I am a student and the assignment is to
identify missing invoices. I cannot readily find the proper method.
Click to expand...

Hint:

Self Join. Add the table to your query grid TWICE.

Use a criterion on the second table's invoice number to find the
gap... details left as part of your homework.

John W. Vinson[MVP]
 
Hi,

Presuming the Invoice table is a child table of, say for example, Orders,
the find unmatched query wizard should identify which orders have no
invoices

If this is not the case, if you can give me more details on the tables in
you DB I can be more specific on the method

Paul
 
Back
Top