I work for a municipality that has a database that I am trying to collect information from.
There are three fields that I am interested in working with.
Permit_Date
Permit_Number
Permit_type
Due to the way the original database was constructed, there are several permit types that have the same permit number. I am trying to construct a query that will allow me to find a specific permit type, and its associated number and any other permits with the same number. This is not just a matter of finding duplicates, but of finding duplicated permit numbers if a certain condition was met. Then if the condition was met, a “N/A” would be entered into the column. Otherwise, a formula that computes the age of the permit without the required permit type would be computed.
I have tried writing various SQL statements, but without success. I don't know VBA, so that is not really an option.
I know this probably sounds confusing, but I was hoping someone could assist me.