Using several tables to make one report

[Guest]

I have setup several tables in one database. I have also setup a report using some of these tables and all went well. But now I want to setup another report using some of my other tables (they are not currently in any reports). The problem is if I use only one of the tables I get a good report, but when trying to use 2 or more of these tables the report doesn't come out correct. The tables are titled FWF-03 Group/Crew A1, repeat title with changing A1 to A2, A3, etc

My fields are
Name (which is the primary key in all tables - no duplicates) (text
Leader (text
Leader Telephone (text - due to "ext"
My other reports from the other tables that I'm not having a problem with, also have a field for a telephone number using text, again because of extensions, the leader telephone numbers in the FWF tables are not the same as the "Name" telephone numbers in my other tables, so there is no conflict there

The other tables I have made separate reports from and a combination report from have a lot more fields in them then does these small tables do. The only difference in these tables is there are no dashes or slashes in the titles, though I can't see how that could be the problem.

Going nuts trying everything I can think of please help
Thank you and God bless
Pa

 

[Duane Hookom]

It's a bit difficult to picture your tables and records. I recommend
against:
- repeating similar tables (why not use just one table)
- spaces and punctuation in table and field names
- field named name which is the name of a property of every object

Maybe if you provided some sample records and how you would expect the
results to look in the report. I can't decide if you need to use a standard
join query or a union query.

--
Duane Hookom
MS Access MVP

I have setup several tables in one database. I have also setup a report

using some of these tables and all went well. But now I want to setup
another report using some of my other tables (they are not currently in any
reports). The problem is if I use only one of the tables I get a good
report, but when trying to use 2 or more of these tables the report doesn't
come out correct. The tables are titled FWF-03 Group/Crew A1, repeat title
with changing A1 to A2, A3, etc.

My fields are:
Name (which is the primary key in all tables - no duplicates) (text)
Leader (text)
Leader Telephone (text - due to "ext" )
My other reports from the other tables that I'm not having a

problem with, also have a field for a telephone number using text, again
because of extensions, the leader telephone numbers in the FWF tables are
not the same as the "Name" telephone numbers in my other tables, so there is
no conflict there.

The other tables I have made separate reports from and a combination

report from have a lot more fields in them then does these small tables do.
The only difference in these tables is there are no dashes or slashes in the
titles, though I can't see how that could be the problem.