Search results

Maybe you could post a sample of your initial table with same dummy data ?

Ok. In query design view once you selected all the fields you want you go and click on property sheet from menu which will then appear on the right side and then within general properties you change Unique Values to YES.I hope this will help. Cheers

Maybe the easiest would be to put this table into query and then set unique values within property sheet to "YES" and then you may create new table from it and delete the old one ? Cheers sanzoo

Yes there are other fields but these cant be used because they represent numeric info wchich varies in both tables...I could do it if access would keep the order while importing the data but for some reason it doesnt...however i can do it by bringing the text files into excel.

but the thing is that I have several duplicates within the fields that are the same ...so when I take your example I have John Smith lets say twice in my table and David Bishop is present 3 times in ther. When I do it as you suggest it will multiply the rows and create another duplicates, right ?

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...

OK I got it problem was with blank ("") fields once covered these it worked like a charm. Thank you very much indeed.

Thank you Paul and Jdraw for the code and suggestion it looks exactly what I need however when I try to use Paul`s code it shows following error message : "Run-time error 5 :Invalid procedure call or argument and highlighting the last line of the code " getUniqueString = Right(endStr...

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 ...

Hi guys, I found out that its not working the way I expected because when I use Brian`s formula and group it Im able to get unique records only for that one Unique(Expr1) field however when I want to have also rest of the records in the query it is duplicating the rows because the rest of the...

Brian`s solution works just fine for me. Yes, RainLover basically its a composite unique ID ...the reason behind is that those 2 Ids represent 2 records each with its own Id and they are in my table next to each other and my goal is to have them in the final query appearing just once because "A"...

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...

Awesome.Thanks John.It works perfectly but one think is unclear to me for instance I have one start date 4.12.2012 and end date 27.12.2012 so it counts 18 days in between but it suppossed to be only 15 as we had 3 day holidays but when I put holiday days into the table and use it in the formula...

Hi John, thanks for the detailed guide however when I ran the function from the query I ended up with following error message 'Compile error: Sub or Function not defined.'. VBA debuger highlighted the first lines where is the function name and 'SkipHolidaysA' in the middle of the script(below)...

Well I did exactly what you told me I pasted the code into the new module and saved it but dont know how to call it specificaly with my query which result I have attached in my thread "sample.xls". I guess I need to somehow specify which fileds are needed to be calculated inside the code...

Thank John indeed for your code. Unfortunatelly Im not very familiar with VBA however I think it shoudnt be a problem to copy and paste this code inside but my question is do I need to rename any names inside the code like variables etc. accorind to my naming and vice versa and if which ones ...

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...