Hi all, I work for a company that has unit numbers such as "BB3465". Very often, we have a run of the same units. These all have a unique unit number but are grouped together in a run i.e. "BB3465-3470". I have created a database to lookup the run schedule and allows me to sort through our schedule by start date/unit#/group, etc. I create a DXF file for the floorplans for each unit or run of units, which is placed in a shared network drive. I usually just paste the network location as a hyperlinked file path in my table and copy it for each unit in a run. So, when the run has 5 units it it, I copy the first cell and paste it into all the ones below within the same group. I'm very certain there is a faster way to do this, especially when there are 150 units in one run.
I'm thinking I need a query to recognize the GroupRange column and make all of the File Location cells within that group range the same, I am just unsure on how to get it to recognize the different groups and then put the same text in each corresponding group and not just put the same text in all of the cells. If the unit does not belong to a group (single unit), then the GroupRange column is blank. I am able to append to the table a given value when the GroupRange column is not blank, but it fills in every run with the same text.