A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Find Matched" Wizard



 
 
Thread Tools Display Modes
  #1  
Old October 15th, 2004, 07:21 PM
Amanda Payton
external usenet poster
 
Posts: n/a
Default "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  
Old October 16th, 2004, 10:17 AM
Brian
external usenet poster
 
Posts: n/a
Default

"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  
Old October 16th, 2004, 10:17 AM
Brian
external usenet poster
 
Posts: n/a
Default

"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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.