Search results

Hello everyone, Here is the tricky one:) I`m trying to put 2 identical tables in terms of structure and layout with some identical values next to each other however I dont have unique identifier. I was thinking to import them and let access to create Id field and match them together but i wasnt...

Hello guys, I have one field where string contains several words separated by semicolon and my goal is to be able to remove duplicates within the string and keep only unique values. Here is an example: initial field: xxx;yyy;ppp;yyy targeted result: xxx;yyy;ppp Any thoughts how this could...

Hello guys, I would need your help with my goal which is as follows. I`m trying to concatenate 2 unique values which are parts of 2 identical rows(records) in order to have only 1 row(record) with concatenated field where the values are unique. For illustration here is what I need to achieve ...

Hello guys, I have one table with following records Id1 Id2 123 456 456 123 444 555 555 444 666 888 888 666 My aim is to get result probably by using query which will contain combination of both Uniques only once doesnt matter if its 123456 or...

Hello guys, I desperately need your help with my query which supposed to provide me with an information about hours between 2 dates/time, the only hook is that I would need to somehow get rid of all the weekends between the dates because the idea of this query is to track SLA and weekends can...