Search results

@Galaxiom I was thinking there was a simple function out there that I was missing, but I guess not. I am afraid an EAV setup is way over my head. I am thinking I may be better off trying to modify our design tool to allow import data from a query instead of a table, assuming that is even...

@thedbguy You are right dlookup is not really what I need because I cant use this funtion to lookup data in one table and copy it to another table. From what I can tell Dlookup is only useful for looking up data in tables and reporting to a form or report which doesn't work for my application.

Sorry the different tables are for the different part types and each table has a different set of fields. The part number and inventory column would be the same fields in all the different tables.

Hello everyone, I have been searching the web for a solution to this without and success and I am hoping someone on this site can help. I am working on importing information from an Excel workbook into 15 different tables in an existing Access database. What I have is a parts library in...