|
| 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
February 8th, 2007, 10:12 PM
posted to microsoft.public.access.queries
|
|||
|
|||
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
February 8th, 2007, 10:57 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
February 8th, 2007, 11:34 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
February 8th, 2007, 11:47 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
February 9th, 2007, 02:36 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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 | |
|
|
Linear Mode
