G
Guest
I have imported a excel file. It started out with names as one field but I
ran a query to split it into two first_name and last_name which is the
format the names in my db are in. I have one table with both name fields and
an employeeID. I have a second table, expenses, with the employee ID and
details about the expenses. Someone yesterday suggested I could run a query
to put the names into the employee table but Im not sure how. The way I tried
with an append query creates a whole bunch of repititious names. I go from
like a couple hundred entries to a couple thousand and have
John Doe
John Doe
John Doe
Joe Smith
Joe Smith
....
My guess is this is somehow because it doesn't know the first name and last
name fields have to be kept together... so I was trying to write a query in
SQL mode that would somehow let me make a new table combining the tables by
first making the names field one field first.......... any suggestions would
be appreciated..
Ryan
ran a query to split it into two first_name and last_name which is the
format the names in my db are in. I have one table with both name fields and
an employeeID. I have a second table, expenses, with the employee ID and
details about the expenses. Someone yesterday suggested I could run a query
to put the names into the employee table but Im not sure how. The way I tried
with an append query creates a whole bunch of repititious names. I go from
like a couple hundred entries to a couple thousand and have
John Doe
John Doe
John Doe
Joe Smith
Joe Smith
....
My guess is this is somehow because it doesn't know the first name and last
name fields have to be kept together... so I was trying to write a query in
SQL mode that would somehow let me make a new table combining the tables by
first making the names field one field first.......... any suggestions would
be appreciated..
Ryan