Show Missing numbers on a report

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

Guest

Hi

I have a report that shows my order numbers. The number format is
TPO/1050/2004
TPO/1051/2004
TPO/1052/2004
TPO/1054/2004
TPO/1056/2004

so on... Is it possible to show on the same report what are numbers
missing. For example , in the above list TPO/1053/2004 & TPO/1055/2004 are
the missing numbers. Is it
possible to do in a report, if possible how to do that. is it an event
procedure

Please provide the code

thanks
 
Hi

I have a report that shows my order numbers. The number format is
TPO/1050/2004
TPO/1051/2004
TPO/1052/2004
TPO/1054/2004
TPO/1056/2004

so on... Is it possible to show on the same report what are numbers
missing. For example , in the above list TPO/1053/2004 & TPO/1055/2004 are
the missing numbers. Is it
possible to do in a report, if possible how to do that. is it an event
procedure
Click to expand...

A couple of problems I see here. TPO/9876/2004 is "missing";
XYZ/1055/2004 is also "missing". What constitutes "missing" for you?
Sequential numbering of the central portion of the order number?

The biggest problem is that your order number is what's called an
"Intelligent Key". Unfortunately that's not a compliment! You're
storing at least two, perhaps three (depending on whether TPO is
constant or variable) pieces of information in a single field. You'll
do much better to have two fields, OrderYear and OrderSeq (Long
Integer), and perhaps OrderCategory (if TPO indicates a category).

It then becomes much easier to identify missing order numbers. The
simplest approach would be to have a table named NUM, with one Long
Integer field N, with values 0 to 9999. An Unmatched Query Wizard will
find all the missing numbers.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top