jobux
09-04-2001, 07:35 AM
Hi all! Having a problem here. I have a database that is set up w/ 3 tables. One listing Names, one listing Quotes attributable to the Names, and one listing Issues implicated by the Quotes. Now, while there is only one Quote per Name, there are multiple Issues implicated by each Quote.
This means that my Issue field contain the abbreviations for many Issues like this: FR MIS CO ECO. Now, how would I create a parameter query that would allow you to search for just one of the Issues in the field, say "CO?" Many Issues? This is why I'm wondering if it would be an "OR' type query. Problem is whenever i try that it only allows me to bring back the results if the 1st Issue of many is input as the query, ex: here - FR.
I'm new at this but I have the single criteria paramter query down, it's just when it implcates many possible Issues that I'm getting bogged down. I apologize for inconveniencing anyone but any help would be appreciated!
This means that my Issue field contain the abbreviations for many Issues like this: FR MIS CO ECO. Now, how would I create a parameter query that would allow you to search for just one of the Issues in the field, say "CO?" Many Issues? This is why I'm wondering if it would be an "OR' type query. Problem is whenever i try that it only allows me to bring back the results if the 1st Issue of many is input as the query, ex: here - FR.
I'm new at this but I have the single criteria paramter query down, it's just when it implcates many possible Issues that I'm getting bogged down. I apologize for inconveniencing anyone but any help would be appreciated!