|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 5th, 2006, 04:06 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Generate Reports from Multiple Tables
How can I generate a report pulling variable fields from multiple tables?
Currently, I have a main table, Employee_Profile that is linked by an Employee_Key field to other tables. When a query is built from two tables the query returns blank results. We do have data input in all forms. Is this a relationship issue within the tables? Thanks. 
|
|
#2
April 5th, 2006, 07:36 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Generate Reports from Multiple Tables
Nash
How does your query link the two tables? Post the SQL statement of your query. Are you absolutely certain that every record in your table1 has a corresponding record in table2? If not, you may need to modify the properties of the join to reflect the fact that you need all from table1 and any from table2. When you say "linked", do you mean that the value in your main table's Employee_Key field is also in a foreign key field in your "other" tables? Regards Jeff Boyce Microsoft Office/Access MVP "Nash" wrote in message ... How can I generate a report pulling variable fields from multiple tables? Currently, I have a main table, Employee_Profile that is linked by an Employee_Key field to other tables. When a query is built from two tables the query returns blank results. We do have data input in all forms. Is this a relationship issue within the tables? Thanks.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| REPOST: Maintaining Page Numbers with multiple reports. | Robin Chapple | Setting Up & Running Reports | 1 | August 5th, 2005 06:53 AM |
| Subform for Multiple Tables | ShdwRider99 | Using Forms | 3 | August 4th, 2005 01:58 PM |
| creating a query or report from multiple tables | petdominic | Running & Setting Up Queries | 2 | February 1st, 2005 11:16 PM |
| Combine Multiple Reports to send in Email Attachment | Steve | General Discussion | 1 | June 5th, 2004 11:06 PM |
| Multiple tables on to one form | LMB | New Users | 4 | May 23rd, 2004 03:35 AM |
Linear Mode
