Hello everyone,
I have a (hopefully) simple question regarding copying a single column of data from several tables into one master table, so I can see if/where they match if at all but I want to see all of the data selected from the other tables in the master table regardless of whether they do match or not.
I have that working and can see all of the columns I want in the master table, but the problem is I am using append queries to populate the master table but it's creating the entries in a staggered format. So the first column I can see the data without scrollling down, but the 2nd column doesn't start showing data until the first columns data ends and so on for the other columns.
So to view all returned records in all columns I have to scroll down the entire page, with each column in turn having data and then being empty when the next column has data and so on.
Am I importing this data in the wrong way in the first place, or can I do something to tidy-up the data once it's all in the master table?
I've looked for a way to delete the individual empty cells in each column so they then all start at the top but cannot find a way to do that, I've also looked at sorting on individual columns but can't find a way to do that either.
I'm hoping I'm missing something obvious so any ideas appreciated, I'm on the verge of exporting the master table to Excel and sorting the columns there to get rid of the empty cells and just re-importing but that seems like giving-up.
Thanks in advance,
Mike.