Joined field is blank

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
 
G

GeoBrooks

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

G
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top