Windows XP 
Access 2007
I'm working on a refund request database that generates an auto number for each request entered into the form. I need a way to generate another number, like a project number, that will be associated with a certain number of requests. For example, I may have 30 requests for one project. Once the project is approved the refunds can be sent. I'd like to update the project as approved or sent, rather than each of the 30 requests. I will need to generate this project number based either on the type of refund or simply on a specific amount of requests keyed each week. Any suggestions would be greatly appreciated. Thanks.
Reply With Quote
