Combining select data from several tables into one report

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.

Sponsored Links:

Related Topics

combining customer and customer contact tables
I have a DB set up with a debtors table (Customers) and a Customer Contacts table, I was thinking of combining these two tables into one. but before I do this, I really want to know the pros and cons of this idea. Has anyone done it this way, and if so, have you experienced issues doing it this way.

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


Report Generation
I'm creating a report right now based on data coming from one of my tables. I've never built a report before and am confused as to how I select what data I want to appear. I have everything set up the way I want it to look, but only want to pull the data that is associated with products that were manufactured after 5/1/2011. How can I select only this data?


New DB Tables Question
Building a DB for my office. Created two tables including Last Name, First Name, Middle etc fields. Both tables have identical Columns but different info. I am trying to create a query or report basically combining the information from both tables into one report or query if possible.sort of like a master list of all the names I need.

Any help would be greatly appreciated as I am needing to get this done in a timely manner.


Select Data Source Won't Cancel!
So I should note before stating my problem that I have been using Access for 2 days now and I don't know much about it at all.

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!


Merging 3 queries into one report
I am sure this is possible but I keep getting error messages or blank data showing 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.


combining 3 tables
I have 3 imported tables namely Sheet_1, Sheet_2 and Sheet_3

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?


update table using sql
I am combining two tables into one to create a report. I want to erase current data in combined table restarting at record 1 each time I pull the report. Doing this with sql code in access 2007. right now, doing erase table, write query 1 to table, append query 2 to table. right now getting messages galore; erasing data, creating data, are you sure? Want to do this without the wonderful messages


A Guide To First Normal Form (1NF)
The goal of normal forms is to remove redundant data from relational database tables by splitting the tables into smaller tables without losing any of the data. It is necessary that the decomposition is lossless, meaning that you can simply come back to the base table by combining the newly created tables with joins.


Combining Multiple Tables
I have 2.5M rows of data split across five tables by year. What's the best way to do this?


Combining multiple tables
I have 24 tables for different student subjects with 10 fields in each. All the fields in each table have the same headings and each field has combo boxs (multi-valued fields) with different data in each to select from. The only similarities (links) between the tables are student numbers. For example; a student with ID 1234 could access 3 out of the 24 tables making selections from the combo boxs (thus they only do 3 out of the possible 24 subjects on offer). I have produced the user interface forms from the tables etc.
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


Selecting multiple tables in a query
I am writing a script to pull information out of 6 different tables. I am currently using these 6 tables to extract stock prices out of google finance and dump this into a seperate table. This program will then take the 6 sets of symbols, combine them into one string, array the string, and then run a macro exectuting queries on each individual stock table the information is dumped into, but im having a problem combining the symbol sets. Below is the code to select the tables and combine them into a string. If I use the current code, I get the error 3704 operation not allowed when object is closed on the .movefirst operation. I use a similar script for for mining the data but I don't combine the stocktables. If I remove the ,dbopentable, dbopendynamic) paramaters I get an error on join data, perhaps im missing a join statement in the select * from query


showing name instead of ID number
iv been using a combo box to show the name of a customer instead of there customer ID in a query.this one has worked fine.

however the second time iv done it for there quad name its left the record black.iv checked over what iv done again and again and can find no difference.now im a bit stumped.

there is also no difference in the relationship (that I know of)

the data the combo boxes are using is coming from a query which is combining data from multiple tables and combining the first name and surname together

im then trying to have the combined name displayed in the combo box instead of the ID number


combining multiple tables in to one master
At the moment I have roughly 200 tables in my DB, I am working on cutting this down to only 7 tables.
Lets say you have two tables with the same fields in each, one of the tables is empty(fields only). How could I import the data of one into the other? The fields are in different positions in each table so at the moment when I run an INSERT query the columns don't line up.
When I import through the external data option it just creates a new table with a "1" on the end!
This would be very handy and Im sure im blind to the obvious answer


Access Report
However had this project thrust upon me. So hence the issues. I am having issues with STS Quotation Model 2 which is a report which is (supposed) to be pulling data from many different tables and supply data for a specific job.

However I think there is a problem with my select query as data was showing foran old record but after I deleted it (It was a test record), It is no longer showing any data.


Report duplicating data
I have a report which brings in data from two different tables. The report is showing data from the two tables but is duplicating data from one of the tables.

How can I fix this?

Please see "Lead Activity Report1" for reference.


Combining Tables into one table
I have 6 tables that have the same Column headings but different data that I need to combine into one table.


Basic report question
I have a report designed through design view that prints out the information from one single table.

I have 2 criteria I need to meet for this report.
1) The report should only ever show the data if the yes/no field is yes.

2) I would like the user to be able to select which particular value of a certain field to use to display only the data for that value. I.e I have a field called Lab with about 30 values right now (it will grow).

I want the user to select one lab name, and the report to print out from that name.

Everything I check on-line is either too basic or too complicated for me.


combining multiple tables in to one master
At the moment I have roughly 200 tables in my DB, I am working on cutting this down to only 7 tables.
Lets say you have two tables with the same fields in each, one of the tables is empty(fields only). How could I import the data of one into the other? The fields are in differentpositions in each table so at the moment when I run an INSERT query the columns don't line up.
When I import through the external data option it just creates a new table with a "1" on the end!
This would be very handy and I'm sure I'm blind to the obvious answer.


Export to PDF and Email Report
I have a report called [Banners Order Confirmation]. What I would like to do is with a click of a button, export the report as a pdf to a specified drive and folder and save it with a name by combining 2 fields from the report. Also, I would like to email this report to an email address which is also specified by a field on the report. I have tried different vb codes and have been very unsuccessful. Could you please help me or at least point me in some dirrection?


Combining Fields from Two Tables
I have a query that does not give the results I want, no matter what I seem to do.

tblBusiness is linked One-to-many with tblBusPeriods and tblCompanyPeriods. In each of the latter two there are dates:- BusYearEnd, BusTarget and CoYearEnd and CoTarget.

I want to be able to see all of the records sorted on the target date from either of tblBusPeriod or tblCompanyPeriod.

When I run the query I get all those companies first, then all the Businesses, with each group sorted. but this isn;t how we need to see the data. I tried combining the fields in the query as: Target Date: ([BusTarget]&""&[CoTarget]). but no data is shown.