I have a database that consists of about 30 tables. These tables have forms associated with them. In the forms I have a combo box, for one of the fields, where the user needs to select which department they are from.
I need to create a query/report using multiple tables based on the date it was completed and the section who completed it.
On my main form I have a combo box for the user to select which section's report they would like to run. That part works, it filters out the correct data, but it puts all the data in a single row.
I am trying to pull the same data from each table, i.e. section, name, date completed, next due, and notes...how do I make it so that those are the only headings and the data is underneath, rather than it displaying a separate heading from each table?
Thanks!