Hi guys I need your help.
I need to create a tool in excel, which will contain data extracted from the sql server (which will be refreshed only by authorized person) and I need to create a page where user can see if with data that they provide to the system, there is a record that corresponds to their query. User can enter 2 or 3 values (ID (alphanumeric), Full name in cyrilic, and date of birth). So search would be exact match of ID (if exists), "LIKE" search of Full name and for date there could be couple of situations (1. same date, 2. switched day and month, 3. same day and month but year is +- 3). And end result would be showing ID, Full Name, DOB, and maybe some additional info.
Thanks in advance.
I need to create a tool in excel, which will contain data extracted from the sql server (which will be refreshed only by authorized person) and I need to create a page where user can see if with data that they provide to the system, there is a record that corresponds to their query. User can enter 2 or 3 values (ID (alphanumeric), Full name in cyrilic, and date of birth). So search would be exact match of ID (if exists), "LIKE" search of Full name and for date there could be couple of situations (1. same date, 2. switched day and month, 3. same day and month but year is +- 3). And end result would be showing ID, Full Name, DOB, and maybe some additional info.
Thanks in advance.