MS access help for New User

  • Thread starter Thread starter New Access User
  • Start date Start date
N

New Access User

I have two excel sheets with data on them. I need to take the first sheet and
import it into access. Then create a new field. In this field I need the
second excel sheet data to line up with data from the access sheet with the
new field. If the ID number on the second excel sheet is on the first, I need
my new column in access to read "yes". I have figured out how to do import
the data from the first excel sheet and how to make a new field. I am
completely lost on how to get the new field to read "yes" without scrolling
through every ID number and then typing "yes". Please help, if you need
clarification please let me know. Thank you!!
 
Import the 2nd spreadsheet into a new table. Then, create a new update query
using table 1 and table 2. Create a join on id number, and change the join
to select all from table 1 and only those that match from table 2. Add your
new column into the query. Then, put something like this into the "update
to" area.
IIf([Table2]![id]=[Table1]![id],"Yes","")
 
Thank you for your responses, I am still a little lost. I have the Query
window open and both tables joined by a line linking them. I am unsure of how
to change the join to select all and only those that match from table 2. I
also do not see an "update to" area....?

Chris said:
Import the 2nd spreadsheet into a new table. Then, create a new update query
using table 1 and table 2. Create a join on id number, and change the join
to select all from table 1 and only those that match from table 2. Add your
new column into the query. Then, put something like this into the "update
to" area.
IIf([Table2]![id]=[Table1]![id],"Yes","")

New Access User said:
I have two excel sheets with data on them. I need to take the first sheet and
import it into access. Then create a new field. In this field I need the
second excel sheet data to line up with data from the access sheet with the
new field. If the ID number on the second excel sheet is on the first, I need
my new column in access to read "yes". I have figured out how to do import
the data from the first excel sheet and how to make a new field. I am
completely lost on how to get the new field to read "yes" without scrolling
through every ID number and then typing "yes". Please help, if you need
clarification please let me know. Thank you!!
Click to expand...
Click to expand...
 
Back
Top