Putting an * when a number is skipped

[Tommy Boy]

I'm trying to indicate on a report when a number is missed on a report.

An example is how the banks do it on a bank statement when a check hasn't
cleared.

In my report I have report lines (in sequential order) that start with a
record numer (like 35,245) with following info on the other fields (name,
etc). I want to make sure all records are entered, so the report might have,
35,245, 35,246, 32,247, 32,249, and 32,250. I would like an * to appear next
to 32,249* indicating that 32,248 is missing. If necessary I could add a
field for the *.

I'd appreciate any help. Tom

 

[fredg]

I'm trying to indicate on a report when a number is missed on a report.

An example is how the banks do it on a bank statement when a check hasn't
cleared.

In my report I have report lines (in sequential order) that start with a
record numer (like 35,245) with following info on the other fields (name,
etc). I want to make sure all records are entered, so the report might have,
35,245, 35,246, 32,247, 32,249, and 32,250. I would like an * to appear next
to 32,249* indicating that 32,248 is missing. If necessary I could add a
field for the *.

I'd appreciate any help. Tom

See Microsoft KnowledgeBase article:
210234 "ACC2000: How to Flag Out-of-Sequence Numbers on a Report"

 

[Tommy Boy]

Thank You so much, worked like a charm.

Tom

 

[Marshall Barton]

I'm trying to indicate on a report when a number is missed on a report.

An example is how the banks do it on a bank statement when a check hasn't
cleared.

In my report I have report lines (in sequential order) that start with a
record numer (like 35,245) with following info on the other fields (name,
etc). I want to make sure all records are entered, so the report might have,
35,245, 35,246, 32,247, 32,249, and 32,250. I would like an * to appear next
to 32,249* indicating that 32,248 is missing. If necessary I could add a
field for the *.

I don't trust that KB article's reliance on having
GlobalFlag in the module. In my experience, the various
KeepTogether options can cause a module level variable to be
set out of sequence. If you run into this effect, try
using a hidden text box instead.