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

[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.

 

[John Vinson]

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.

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]

 

[Paul Doree]

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