I have a database for Employees and I have the employee ID prefixes in different format in combobox for which they will be given according to the project. For example: I have few employees under Transportation project and they are given the Prefix of "LSB" and for construction project "TDN" and the four digit employee ID No is given manually starting from 0001 (Indexed-Yes (No Duplicates). On the query form I have created a new column as Employee Project ID Number and I need to concantenate Project ID Prefix and Project Number to get a result "LSB0001" or "TDN0002" and so on and so forth. I did a formula for Project ID Number: [Project ID Prefix] & Format([Project ID No],"0000"), but I am not getting the result I am expecting. Please help. Thank you
-
-
Hi Jerry.
Welcome to Bytes.com :-)
Have a look through Item Numbering Within a Group first. This should give you absolutely everything you need. If you do find yourself needing more help though then let us know and we'll do what we can for you.
Comment