Joined field is blank

  • Thread starter Thread starter GeoBrooks
  • Start date Start date
G

GeoBrooks

I'm working in Access 2000 on converting a client's spreadsheet to a
database. In the simplest terms, there are two sheets, one with mothers'
names and data, one with baby's names and data. The babies sheet also has
the mother's name. I've imported both tables into an Access db. So to begin
with I have a mothers table with fields id, fullname, and a babies table with
baby's name and mother's fullname. (Parsing the fullname into last & first
is easy and already done.)

I have built a query using both tables. Without specifying a join on
fullname, I of course get the Cartesian product of the tables. When a join
is specified, the left side will display fullname, the right side is blank.
When I remove the join and include expressions to calculate the length of
fullname, the left side of the join shows the correct value, the right side
shows 1. (I have confirmed, using Excel, that the fullname values in the two
tables are equal.)

I'm stumped. I was hoping to use this to create an update query to get the
id value into the babies table. Any clues as to how best to tune this up to
make it work?

TIA

George
 
Never mind! Left hand is now introduced to right hand. Synapses rejoined.
Problem solved.

G
 
Back
Top