What I have:
tblPersonal
-EmployeeNumber
-LastName
-FirstName
-MI
qryCommon
-EmployeeNumber
-NameLFMI: IIf([tblPersonal.MI] Is Null,[tblPersonal.LNAME] & ", " & [tblPersonal.FNAME],[tblPersonal.LNAME] & ", " & [tblPersonal.FNAME] & " " & [tblPersonal.MI] & ".")
-NameFMIL: IIf([tblPersonal.MI] Is Null,[tblPersonal.FNAME] & " " & [tblPersonal.LNAME],[tblPersonal.FNAME] & " " & [tblPersonal.MI] & ". " & [tblPersonal.LNAME])
-etc...
My question:
I created qryCommon basically as a code repository for quickly copying code I use over and over so I don't have to retype. Is it better practice to:
1. Copy the code into every query I need it in
-OR-
2. Include qryCommon in the other queries
I see plusses to both. 1-less possibility of a conflict 2-less code=smaller FE size.
I just am wondering what the best practice is since I am basically creating a new database do to the "shortcuts" I have in my current one.
Thanks in advance for your input. Have a great day!