Search results

I get dumps of system data each week, and I need to audit the changes made. The tables are identical in structure, and much of the data is the same. Product_Code is my primary key, but if any of the attributes change, I need to be able to find them easily. I have the tables set up showing...

Hello, I have two tables in identical format (comparing two weeks of product data). I need to create a query to identify all of the changes made to this data. I know I could write an Iif statement to compare each of the 70 fields, but I would like to not spend the rest of my life writing...

I must admit, my knowledge of how to work code is extremely limited. I can't figure out the CopyFromRecordset - have you done this before? If I could see some working code I may be able to get the idea.

I have code for a crosstab Query and I need to figure out how to make my Excel macro dump it into a spreadsheet for me. With my "normal" queries I've been able to do this in this manner: Range("A" & intLineNum).Value = rst1!dataName and proceeding through the different values. How does...