Search results for query: *

Okay, well that answers that question. The reason I went to autonumber is because I am pulling in data from a mainframe that stores data by a unique sequence code (alpha/numeric) to keep track of aircraft configurations. Without the autonumber, I could not keep the file in a top down sequence...

I have a split database, one on the desktop and other out on the network. My tables are autonumberd to keep the records in a particular sequence. I also created queries one to delete and one to update the tables. After deleting the data in a table I compact and then do an update. This...

JoaoTL, Sorry I didn't get back sooner....I sent a sampling of the database to your email address so you can see what I am working with. Would like to be able to compare multiple fields at once. Thanks in advance

Good point about the relationship...I didn't set up a relation between the two yet(and logically I would need to do that first). I have an Autonumber field in each table, but that would not necessarily be the same in each table to use in a relationship. Would I have to relate all fields used in...

Actually two tables. The structure of both are identical.

I want to compare two databases, the current database against last months data. It needs to be flexible enough so I can select which fields to compare on and be able to select multiple fields at a time. What would be a recommended approach. I tried using the built-in compare query in Access...