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
|
|||
|
|||
Show result of TblA not in TblB
I have a main tblA with all clients. If they have any current contracts they
are in tableB. How do I show the clients of A that are not in B? Thanks Ian. |
#2
|
|||
|
|||
Show result of TblA not in TblB
I believe there is a query wizard that walks you through this. Come back if
you can't find it on your own. -- Duane Hookom Microsoft Access MVP "Ian" wrote: I have a main tblA with all clients. If they have any current contracts they are in tableB. How do I show the clients of A that are not in B? Thanks Ian. |
#3
|
|||
|
|||
Show result of TblA not in TblB
don't think the wizard will help with this because in the select on client in
TblB I have some other JOINS going on to select out the appropriate list. I usually use the design view but can do it in SQL if I have too for UNION joins and stuff. I know it's a silly question but for the life of me I can't think of the logic I need to use to exclude the show only the clientID's in TableA that are NOT included in TableB. All the joins I usually use only let me show ID's that are included in both tables one way or another. "Duane Hookom" wrote: I believe there is a query wizard that walks you through this. Come back if you can't find it on your own. -- Duane Hookom Microsoft Access MVP "Ian" wrote: I have a main tblA with all clients. If they have any current contracts they are in tableB. How do I show the clients of A that are not in B? Thanks Ian. |
#4
|
|||
|
|||
Show result of TblA not in TblB
On Thu, 8 Feb 2007 14:12:01 -0800, Ian
wrote: I have a main tblA with all clients. If they have any current contracts they are in tableB. How do I show the clients of A that are not in B? Use the "Unmatched Query Wizard" in the Query window (new query, use the wizards). John W. Vinson [MVP] |
#5
|
|||
|
|||
Show result of TblA not in TblB
still couldn't do it in SQL if I wanted to but it worked like a charm.
Thanks guys. "John W. Vinson" wrote: On Thu, 8 Feb 2007 14:12:01 -0800, Ian wrote: I have a main tblA with all clients. If they have any current contracts they are in tableB. How do I show the clients of A that are not in B? Use the "Unmatched Query Wizard" in the Query window (new query, use the wizards). John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|