Access Report

D

Derek

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.
 
D

DL

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
 
Top