Hello all,
I have to create a report from an Access DB that has 20 tables. I pretty much need all the fields from all the tables.
I need the info to be ordered by staff name (Staff is the main table) and then all the other information from the other tables that relate to that same staff person to be under him/her.

if i use the wizard it says that i have pulled fields from multiple tables/queries (which i did) and it cant do anything.
Do i have to create a HUGE query first?

Thanks a lot

I also have a form to populate the DB. is it possible to generate the report from there?