General discussion

Locked

Access 97 Query

By loydster ·
I have a query with 2 fields. One is a Slip number, which is a number that should increment by one for each record.

Is there anyway to have access tell from one record to the next if the number goes up by more than one? ie. a Slip has been skipped.

These numbers are hand entered, because they relate to hard copies. It cannot be auto incrememnt.

Thx, Loyd

This conversation is currently closed to new comments.

23 total posts (Page 3 of 3)   Prev   01 | 02 | 03
Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 97 Query

by kees.valkenswaard In reply to Access 97 Query

If you want that Access warns you that the number is not he highest + 1 that would also require a macro. If you design a form it is not that complicated to offer as default the value Highest + 1. However, what are you going to do if the number is highest + N [N>1]. Taking a pencil to write down that you missed one? I still think that my query would be useful. If you print the result you know at least which ones are missing.
If you want to mail me put Q&A as part of the subject line. Else the message would be deleted with this address.

Collapse -

Access 97 Query

by loydster In reply to Access 97 Query

Sorry guys...the last one was easiest for my n00b mind to understand :)

Collapse -

Access 97 Query

by loydster In reply to Access 97 Query

This question was closed by the author

Back to Web Development Forum
23 total posts (Page 3 of 3)   Prev   01 | 02 | 03

Related Discussions

Related Forums