OK... here goes...
I have one table with member no (our unique id), member value and member products and another table with member no and about 20 other columns. I want to combine the two- the only problem is that the 2nd table has some members that the first table doesn't have (table 2 is longer). I want a table that has everything from the 2nd table, plus the extra 2 rows from the 1st table- and I'll want it every month (using fresh data).
I've tried the data, consolidate thing and can't make sense of it and I can't seem to install the wizard. Pls help.
I have one table with member no (our unique id), member value and member products and another table with member no and about 20 other columns. I want to combine the two- the only problem is that the 2nd table has some members that the first table doesn't have (table 2 is longer). I want a table that has everything from the 2nd table, plus the extra 2 rows from the 1st table- and I'll want it every month (using fresh data).
I've tried the data, consolidate thing and can't make sense of it and I can't seem to install the wizard. Pls help.