Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Query Help - is there an ONLY function
Hi everybody
I would like to know how you define a query to return ONLY something and not either, or. Example Company 1 supplies BOTH catagories (Domestic and Commercial) Company 2 supplies ONLY Domestic if you had two companies who supplied equipment and two catagories (Domestic and Commercial). If these two companies supplied Commercial equipment and one of these two ONLY supplied Domestic. How would you go about displaying the one supplier that ONLY supplied both catagories. But you don't know which company before you do the query so you would not be able to have the company name as a criteria - if you see what I mean In this case the answer would be Company 1. But how do you get Access to do this. Any help would be great. Thanks BOB8000 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Query Help - is there an ONLY function
You would use a query in Access. It would be necessary to know exactly what
is entered in the field to be able to advise the criteria to be applied. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "bob8000" wrote in message ups.com... Hi everybody I would like to know how you define a query to return ONLY something and not either, or. Example Company 1 supplies BOTH catagories (Domestic and Commercial) Company 2 supplies ONLY Domestic if you had two companies who supplied equipment and two catagories (Domestic and Commercial). If these two companies supplied Commercial equipment and one of these two ONLY supplied Domestic. How would you go about displaying the one supplier that ONLY supplied both catagories. But you don't know which company before you do the query so you would not be able to have the company name as a criteria - if you see what I mean In this case the answer would be Company 1. But how do you get Access to do this. Any help would be great. Thanks BOB8000 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge Query - Works in Access; fails in Word | Mailmerge | |||
VBA function results in fields | Microsoft Word Help | |||
Word Compare and Merge Document Function | Microsoft Word Help | |||
Mail Merge not running properly from Access Function but runs properly when opened manually | Mailmerge | |||
Can't Open Data Source (Query) where criteria is defined by functi | Mailmerge |