I have Access 2007. I have 5 tables that I need to pick fields from to make a report. When I run a report, I get the proper headings but no data appears. I can run a report on one table and that works great. But not what I need. I am not experienced so need someone to walk me through this.
This is supposed to be better than Excel but I am now wondering.
First table - Drug Info has 12 cols and I want to pick 2 for my report.
Second table - Regulatory Info has 13 cols and I want to pick 2 for my report.
Third table - Specific Info has 9 cols and I want to pick 1 for my report.
Fourth table - CDR Infor has 12 cols and I want to pick 2 for my report.
Fifth table - BC has 26 cols and I want to pick 3 for my report.
I tried using a query and I tried using a report and all I ever get are the column headings with no data. Arghhh. HELP!