Search results

All, Thank you for your feedback. Given the limitations, I've chosen to implement my own columns table, and use that to "unpivot" the data tables when needed. Here is the code i am using to create/update the columns table and the query to "Unpivot" a table's data using the columns data...

I want to replace an iterative loop by using a query of columns from a "Data Dictionary" table, linked to a regular data table to insert a number of values at once into a history table, rather than run through each field in the recordset, compare it to its previous value and insert it...

Try this. In the Design View, link the Contact ID to the Owner ID, then switch to the SQL View for the query. In the SQL View find the syntax for the join statement which should be something like FROM [Contacts] INNER JOIN [Project Info] ON [Contacts].[Contact ID] = [Project Info].[Owner...