Unanswered: Combining 3 3-column tables into 1 3-column table
I have 3 tables with the same schema, Column A is a unique ID, Column B is a Date, and Column C is a text field (length=100). Now, is there a way to collapse the table so that I can have the same schema, but have all the dates lined up in one table? I want to create a report with chronology by date. I'm guessing I need to build a query in Access to be able to do this.
The second enhancement: I'd like to have this kind of table collapsing for reports - is there a way to collapse these and then color code each entry based on which table they came from?
SELECT ColumnA, ColumnB, ColumnC, "Table1" AS Source
SELECT ColumnA, ColumnB, ColumnC, "Table2" AS Source
SELECT ColumnA, ColumnB, ColumnC, "Table3" AS Source
You can use conditional formatting and that "Source" field I added to get your colors on the report.
For the coloring, I have gotten to the conditional formatting dialogue. There are only two choices though, a Field Value and an Expression. I basically want to say if Source="A", then color all three columns red, if "B", then all three columns blue. Can this be done?