After playing around with this at work today I think this will work very slick. Thank you all for your replies.
Mike
memiles
Last Activity: Dec 1 '09, 08:09 PM
Joined: Nov 24 '09
Location:
-
It will be going to the FAA so must be absolutly accurate.
MikeLeave a comment:
-
This is tens of thousands of lines of data.Leave a comment:
-
Ok... Table 3 will be a new table based on tables 1 and 2, created from tables one and two. Tables one and two are access tables imported from excel workbooks.
When everything is done I want to send the excel workbook to who ever using db queries.
Does this make sense?
Mike
Mike. If you need I can send data so you can understand.Leave a comment:
-
Would this be VBA? I looks like it might work. little lost.Leave a comment:
-
vlookup vs access
Table 1
Part number, Data, Data1, Data2.....
(Part Numer in this table is duplicated multiple times)
Table 2
Part Number, Data 3......
(Part Number in this table is not duplicated)
I would like to create a new table
Table 3
Part Number, Data, Data1, Data2, Data3
I can do this in excel with a vlookup however would like to do this in access
...
No activity results to display
Leave a comment: