Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database Question
I have a database that tracks Quotes. On a userform (that reads/writes to
the database) i have a button that inserts the quote number. if the user is quoting a new job, i search the 'Quote Numbe' column for the max, then add 1 to it for the new job number. This works fine. the problem is ifI the user is Re-Quoting a job, i just want to add 0.1 to that Quote Number from the Originial time it was quoted. Example: if a job was quoted once, and received a Quote Number 5000. If the user wants to quote that job again, i want the quote number to be 5000.1 then if he wanted to quote it a third time, it would be 5000.2 I just need a way to look for the project name (ComboBoxProjectName.Value) in column A of the database, then add 0.1 to the largest number for that project. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Database Question? | Excel Discussion (Misc queries) | |||
Database question | Excel Programming | |||
Users database question | Excel Discussion (Misc queries) | |||
Database Question | Excel Programming | |||
Database question | Excel Programming |