If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Find Matched" Wizard
Hello!
I have been finding recently that as I go to build queries, and the query wizard pops up, that none of the options REALLY match what I want to do. I occasionally end up with identical records in two tables - one that is SUPPOSED to hold records that are orders in pre-production state, and one that is SUPPOSED to hold records that are in production and post production state. (basically devides whether a user can edit the record, or just view it). However, since my post production table is frequently populated by a mass import that contains both sets of information, it would be useful to be able to be able to find records that match records in another table (somewhat the opposite of the unmatched query wizard). Maybe I just don't know of an easy way to set this up - but I'm having to create a couple of Unmatched queries in order to filter out what I want to delete from my post production table. Hope that makes sense. Amanda |
#2
|
|||
|
|||
"Amanda Payton" wrote in message
news Hello! I have been finding recently that as I go to build queries, and the query wizard pops up, that none of the options REALLY match what I want to do. I occasionally end up with identical records in two tables - one that is SUPPOSED to hold records that are orders in pre-production state, and one that is SUPPOSED to hold records that are in production and post production state. (basically devides whether a user can edit the record, or just view it). However, since my post production table is frequently populated by a mass import that contains both sets of information, it would be useful to be able to be able to find records that match records in another table (somewhat the opposite of the unmatched query wizard). Maybe I just don't know of an easy way to set this up - but I'm having to create a couple of Unmatched queries in order to filter out what I want to delete from my post production table. Hope that makes sense. Amanda Hi Amanda, Separating the records into two different tables is just asking for problems of the kind you describe. It would be far better to have just one table, with some kind of status field that gets updated as things change. Anyway, to find matching values in two tables all you need is a simple join. Open the query designer, add both of the tables, and just click and drag from the matching field in one table to the matching field in the other to create a join. |
#3
|
|||
|
|||
"Amanda Payton" wrote in message
news Hello! I have been finding recently that as I go to build queries, and the query wizard pops up, that none of the options REALLY match what I want to do. I occasionally end up with identical records in two tables - one that is SUPPOSED to hold records that are orders in pre-production state, and one that is SUPPOSED to hold records that are in production and post production state. (basically devides whether a user can edit the record, or just view it). However, since my post production table is frequently populated by a mass import that contains both sets of information, it would be useful to be able to be able to find records that match records in another table (somewhat the opposite of the unmatched query wizard). Maybe I just don't know of an easy way to set this up - but I'm having to create a couple of Unmatched queries in order to filter out what I want to delete from my post production table. Hope that makes sense. Amanda Hi Amanda, Separating the records into two different tables is just asking for problems of the kind you describe. It would be far better to have just one table, with some kind of status field that gets updated as things change. Anyway, to find matching values in two tables all you need is a simple join. Open the query designer, add both of the tables, and just click and drag from the matching field in one table to the matching field in the other to create a join. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
find duplicate wizard HELP!!!! | stelios | General Discussion | 2 | October 5th, 2004 11:58 AM |
query wizard error | Christen | General Discussion | 12 | August 13th, 2004 08:37 PM |
find and replace | ladyinred | General Discussion | 14 | August 12th, 2004 09:35 PM |