Lookup value from old table to new

[joshandsony]

Hi All,

I need some serious help. I have an excel file that I update constantly. When I bring a new file into access twice a week, I move the old one to a make table called "Expedite Raw Old". Then when I bring in the new table, I call it "Expedite Raw". What I need to do is lookup a PO # in "Expedite Raw Old" and bring over the "Ship flag" from the old report to the new one using the PO # as the same info from each report. How can this be done simply? I tried using a lookup column, but it doesn't return any values.

 

[HiTechCoach]

Hi All,

I need some serious help. I have an excel file that I update constantly. When I bring a new file into access twice a week, I move the old one to a make table called "Expedite Raw Old". Then when I bring in the new table, I call it "Expedite Raw". What I need to do is lookup a PO # in "Expedite Raw Old" and bring over the "Ship flag" from the old report to the new one using the PO # as the same info from each report. How can this be done simply? I tried using a lookup column, but it doesn't return any values.

I would try using a query and join the two table on the PO#