Reply to thread

Message: [QUOTE="Greg McLandsborough, post: 2560876"] I have a Table the contains a Document_ID, Project_ID and a Document_Number. The Document_Number is a more user friendly (descriptive) version of the Autonumber sortof. It contains a Discpline_ID and a Document_Type_ID and sequential Number. The sequential number is not equal to the Autonumber, It is instead the next available number for that particular project, of that discipline and type. How do I create a query that will make a number of this format ? Thanks for any help... Greg [/QUOTE]