Query

  • Thread starter Thread starter par428
  • Start date Start date
P

par428

I have a master list of surgical procedures and comparing it to the past 2
years of procedures from that list. I want Access to tell me which procedures
from the master list were NOT done in that 2 year span.
 
par428 said:
I have a master list of surgical procedures and comparing it to the past 2
years of procedures from that list. I want Access to tell me which procedures
from the master list were NOT done in that 2 year span.
Click to expand...

Try creating a new query using the Find Unmatched query
wizard.
 
Thanks for your help Marshall,
I attempted to do what you said...I clicked on "new" and selected "Find
Unmatched Query Wizard"....my two tables were listed.
Table:Current Procedure Listing
Table: Procedure Rank Last 2 Years
I selected them both....I then matched two common fields called "Mnemonic"
and "Description".....I then placed both fields on my query result and viewed
the query....this gave me a large listing of procedures.......but when I
randomly selected procedures to validate whether they were booked in the past
2 years......I found a few. Which is not what I wanted.
Any other suggestions?
 
par428 said:
I attempted to do what you said...I clicked on "new" and selected "Find
Unmatched Query Wizard"....my two tables were listed.
Table:Current Procedure Listing
Table: Procedure Rank Last 2 Years
I selected them both....I then matched two common fields called "Mnemonic"
and "Description".....I then placed both fields on my query result and viewed
the query....this gave me a large listing of procedures.......but when I
randomly selected procedures to validate whether they were booked in the past
2 years......I found a few. Which is not what I wanted.
Click to expand...


Post a Copy/Paste of your query's SQL view and we'll try to
straighten it out.
 
Back
Top