Hi I see there are some very smart people in this forum, maybe one can help me.
I have customer data I am about to import to Access and have an addressID (unique to each address), I wnat to allocate that ID to a very long list customer orders. the common number is tthe Customer id. eg Customer ID 12 has addressID 1. in the customer orders list each customer ID may have between 1 and say 50 orders. Rather than copy and paste the address ID (there are over 800 addresses) for each customer I wonder if there is a method to identify the customer id (in the orders list) and allocate the appropriate address id. So in effect i have two lists one 800 rows long and one over 5000 rows long. the Customer ID is not unique in either list (as some customers have several addresses). Hope this is enough info and thanks for any help
Configuration: Windows Vista Firefox 3.0.1
Bracket excel formula Copying excel formula from one row to another Excel formula 80>100 = a* Excel formula display data in two digit format Excel formula figure convert into alphabet Excel formula for date plus 3 years Excel formula for invoice numbers Excel formula having if Excel formula help, if column empty move to next column Excel formula make value bold Excel formula match in list of columns Excel formula matching data Excel formula show only if Excel formula to change font color Excel formula to count date Excel formula to display only part of text cell Have start and end date but need excel formula to show dates in between Why put a ,0 in a excel formula 2007