Access Report

I have an Access report that pulls from 2 different tables. the main table I
have a first and last name field, and the 2nd table I also have a first and
last name table. I can concantenate from the first table and combine the
first and last name fields into one text box on the report, BUT, when I try
to do the same for the second table it won't work. I have even tried using a
query, and while the query works, when I put it on the report it can't find
any information from the query. Please help.

Are these name fields duplicates in both tables?

"Derek" <Derek@discussions.microsoft.com> wrote in message
news:C0400073-7D15-4750-8E81-280B8331B770@microsoft.com...
> I have an Access report that pulls from 2 different tables. the main
table I
> have a first and last name field, and the 2nd table I also have a first
and
> last name table. I can concantenate from the first table and combine the
> first and last name fields into one text box on the report, BUT, when I
try
> to do the same for the second table it won't work. I have even tried
using a
> query, and while the query works, when I put it on the report it can't
find
> any information from the query. Please help.

They are.

"DL" wrote:

> Are these name fields duplicates in both tables?
>
> "Derek" <Derek@discussions.microsoft.com> wrote in message
> news:C0400073-7D15-4750-8E81-280B8331B770@microsoft.com...
> > I have an Access report that pulls from 2 different tables. the main
> table I
> > have a first and last name field, and the 2nd table I also have a first
> and
> > last name table. I can concantenate from the first table and combine the
> > first and last name fields into one text box on the report, BUT, when I
> try
> > to do the same for the second table it won't work. I have even tried
> using a
> > query, and while the query works, when I put it on the report it can't
> find
> > any information from the query. Please help.
>
>
>

Then at the least that is bad db design, which could cause further problems
& why would you want to have these duplicate names showing in the report?
I'd perhaps suggest that you redesigned your db to make use of
relationships, things might go easier then.
http://www.databaseanswers.org/data_models/index.htm may offer some insight
into db design

Is any field from the second tbl, or query available in the report

"Derek" <Derek@discussions.microsoft.com> wrote in message
news:2D2B8E53-84BB-4244-A1B8-51F9D16214C9@microsoft.com...
> They are.
>
> "DL" wrote:
>
> > Are these name fields duplicates in both tables?
> >
> > "Derek" <Derek@discussions.microsoft.com> wrote in message
> > news:C0400073-7D15-4750-8E81-280B8331B770@microsoft.com...
> > > I have an Access report that pulls from 2 different tables. the main
> > table I
> > > have a first and last name field, and the 2nd table I also have a
first
> > and
> > > last name table. I can concantenate from the first table and combine
the
> > > first and last name fields into one text box on the report, BUT, when
I
> > try
> > > to do the same for the second table it won't work. I have even tried
> > using a
> > > query, and while the query works, when I put it on the report it can't
> > find
> > > any information from the query. Please help.
> >
> >
> >