Using two tables for one report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that lists names & cell phones. The names are pulled from an
ODBC source as well as the cell phones numbers at the moment along with other
info that the report contains. The problem- most of the cell phone numbers
are blank. I have an excel file I have imported into Access with the names &
cell numbers into a table. I want to be able to tell the report that if
field_name is = to Joe Smith then look at table tbl_Cell_Phones to pull the
number from that table.

This would be SO much faster than entering all 1100 records!

Can I do this? If so, how?

Thanks!
 
Hi,


SELECT Table1.*, CellPhones.cell_Phone
FROM table1 LEFT JOIN CellPhones
ON table1.field_name = CellPhones.field_name



saved as a query and use that query as record source for your report.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top