So for simplicity, say I have a table with one field, called ID. It has three records {ABC, DEF, GHI}. How can I use a query to end up with a table with ID and ID2 (new field) which will look like such:
ID ID2 ABC ABC ABC DEF ABC GHI DEF ABC DEF DEF DEF GHI GHI ABC GHI DEF GHI GHI
In other words - for each ID, there would be a corresponding ID2 equal to all ID values from the original table.