Unselect query

[Megahurtz]

OK I know this is a easy one I am just stumped on it and can't find any good info in access help
I have
Master table Contains All users (CN=key field)
Active table Contains Active users (CN has multiple user entries)
both join on CN

How do I query for the the non-active users?

I have tried Not and <> in Master.CN for criteria example: <> [Active]![CN]

I have also tried as an expression

I still seem to be getting 311 ( Active records ) or
924 ( Master records) I need the difference of 613 records in a make table query called Inactive

Thanks in advance

 

[jebry]

Hi!

Make a new query and use the Find unmatched query wizard. That should step you through the process.

hth
Jeff Bridgham

 

[Megahurtz]

Thanks, That worked perfectly!!! Is Null was the ticket

I usually do all my own queries by hand or use SQL code and convert that !!

-Mega-

 

[THoey]

Wouldn't it be better to have just one table and add a field whether or not they were active or not? Terry M. Hoey

 

[JoeMiller]

It would certainly be easier to maintain Terry!! Joe Miller
joe.miller@flotech.net

 

[jebry]

I would have to agree with both of you on that one! But before I recommended it to Megahurtz, I would want to know what was meant by multiple user entries in the active table. It sounded like a one-to-many relationship so that's why I gave the answer I did. But I should have verified that before answering.

Jeff Bridgham

 

[THoey]

Hey Jebry, no problem at all with the solution you gave. I just mentioned this because if it is this difficult to get this simple query problem solved, what is it going to be like when they have to do something complex with the data? Terry M. Hoey

 

[Megahurtz]

This DB wont get complex

I was tasked with extracting out a list of users who have registered to a particular website but have not hit hte site since they recieved their login/pwd

What I had was a table of all reg users CN and a table on CN's that hit the site. It is one to many relationship but this was just for a ad-hoc report for a manager while his reporting tools were being developed. He wanted to follow up with people who registerd but haven't visited.

Thanks to all of you for your input
I am glad i happened upon this site yesterday |-0