Allow adding serial numbers from to

[Kallu]

I have table to register filled receipt costumer,receipt are with serial numbers,book has 20 receipt, steward are charge with book, and are registred in another table, example
Name: John Smith, receipt from: 202021 to 202040
Can u make code to allow adding receipt from 202021 to 202040 only yo John Smith, and to be informed when all 20 receipt are registred on database.
Thanks in any advance

 

[vbaInet]

Kallu I've read your post over and over again but I'm struggling to make sense of it.

If you want to allocate 20 receipt numbers per customer then it's either you create the 20 receipt numbers for a new customer or get the first receipt number from the last added customer and add 21 to that to get the first receipt number for the new customer.

 

[missinglinq]

I've been looking at it for 48 hours, also without being able to make heads or tails out of it, which, I suspect, is the reason it's been viewed by 62 people here and 58 people on another site without any suggestions being posted!

Not trying to be unkind, here, but we really need a clearer explanation of your needs.

Linq ;0)>

 

[gemma-the-husky]

Ok - what he wants is this. I think.

1. when a receipt is entered, establish who it was issued by, relative to ranges of receipts.

2. to be able subsequently to verify that all receipts in a range are presenty.



so - given a receipt number, do a dlookup in your receiptbook table to find the owner of the book.

startnumber<=receiptnumber and endnumber>=receiptnumber will identify the book in question.

if you do a query selecting receipts between a startnumber and an endnumber, then a complete list will have endnumber-startnumbert+1 rows. if you have some missing, then you would have to iterate a recordset to find exactly which.