Combining select data from several tables into one report
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.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Reason for my thinking of doing this is: some of my debtors are the contact.
In other words.Most of the Debtors are companies, but a few are actual people. With the current setup, I need to have both a debtor and a customer in two different tables, but with exactly the same data.
Please I am really looking for some constructive advice for both for and against, so I can then really make a well thought choice, rather than combining the tables only to have further issues down the line
Any help would be greatly appreciated as I am needing to get this done in a timely manner.
I have a SQL 2008 database on a network drive. It's full of all kinds of tables, and stored procedures. Now I went over to ODBC and linked it in, so I can see all the tables. Then I proceeded to writing a few queries that return tables.
Then I went over to report and dragged and dropped the query into the report. My hope was that the report would run that query and return the proper data.
If I run the query alone, it works great, but once it's in the report I keep getting a "Select Data Source" window that pops up. I click the tab "Machine Data Source" select my data source name (type is system).
the same window immediately pops up again! No matter what I do, I keep getting the same pop up!
What I am wanting to do is pull information from the data table based on academic year. I have the queries set up to pick data between certain dates which works fine in the query. When Iwant to use the queries to produce a report - ie combining 3 years worth of data for a member of staff against their staff code - no data is showing up.
I have set the field properties in the report to select from the right query and based the form on the table (not a query) but it won't bring the data up for me.
They have the same field names now I am looking for a solution in combining them into one table and name it tbl_ProjectList.
I need to do this through a button cmd_UpdateProjectList, what I need to do all this staff?
And can anyone help how to figure out my VBA code for my cmd_UpdateProjectList?
What I need to do and cant is have all the data from all the tables dump into the one table then I can query the table and extract (group) the students answers under their one student name. I have tried Union queries and appending and SQL but all seem not to be able to work with multi-valued fields (combo boxs). Im new to access and teaching myself as I go