Search results

Hello - I have a database with bunch of identical tables. Tables: same table structure auto generated every day. I want to make all the tables into one table . I want to keep all the records (do not want to take the duplicates out). Please help me with this . Thanks for looking

How Can I transpose the Following: Can you help me write a query in Access to transpose the data Table : Transpose ID score course 1 3 M 1 4 C 1 T 1 4 E 1 4 M 1 5 C 1 2 T 2 M 2 3 T 2 5 E 2 11 R 3 3 M 3 4 C 3 6 R desired output ID M C T E R .. 1 3 4 - 4 - 1 4 5 2 - - 2 - - 3 5 11 3 3 4 - -...