Hi all
I am trying to do a query where I pull data from 4 tables. The 4 tables are Quarter1, Quarter2, Quarter3 and Quarter4. From each table I want to pull PayDate and Done. Each PayDate and Done is prefixed by the appropriate Quarter e.g. QTR1PayDate, QTR1Done.
PayDate is a date/time field...