Hi All,
I am new to Access and found this forum great help during one of my last issues.
I built a small Access database for a Team at work which collects the following information.
Name
serial Number
Date entered
Lead name
I have also made this table searchable by serial number. So a user enters a serial number into a field and any entry with that serial number is returned. The req changed from one serial number to up to five per entry. I just had 5 text boxes available to submit each serial number into a Table INTO FIVE DIFFERENT ROWS. However, as of this morning i have been asked to cater for 20 Serial numbers per entry. It does not make sense for me to have twenty new rows in my table, it does not seem efficient or correct.
I have been googling and discovered that maybe i can use a split? I want the user to enter multiple values like this
Serial Number: SN1,SN2,SN3,SN4,SN5,SN6,SN7,SN8
and I want to be able to search an entry for a specific serial number. If the entry holds SN1 the whole entry should be returned.
So i want to use a comma as a delimiter. Will these then be stored in the database as one field or do i need to make changes?
Can anyone help me get started here? Just explain it to me as all the code examples online are confusing me