unique

putting records in new table that don't have 6 or more different addresses for same name - Microsoft Access

Hey all, If the names repeated is more than 6 and there are six different addresses for that same name, then I don't want to output them to the KeepThese table: harry baker 1 street harry baker 2 street harry baker 3 street harry baker 4 street harry baker 5 street harry baker 6 street donald ross 11th street So harry baker should be...

Help with select MS Sql Select statement...

Hello, I have a table like the following table: UserID Num1 Num2 Code Name Cat 7293 32:16.0 50:22.0 3 Jim 33 7293 32:16.0 59:28.0 4 Jim 12 7316 32:16.0 55:32.0 4 Karen 33 7316 32:16.0 28:31.0 4 Karen 7 7287 32:16.0 01:27.0 2 Mike 33 7299 32:16.0 18:53.0 4 Sue 16 7302 32:17.0 54:54.0 ...

algorithm for functions permutating integers

Hi, I want to write a function y = f(x) and another function x = g(y) that acts as a reversible, where y = f(g(y)) and where x and y are permutated integers. For very simple example in the range of integers in 0 to 10 it would look like this: 0->1, 1->2, 2->3,..., 9->10, 10->0 but this is the simplest method by adding 1 and reversin...