Re: Query problem
- From: "[MVP] S.Clark" <steve.clark_NOSPAM@xxxxxxxxxx>
- Date: Thu, 5 Jan 2006 18:39:12 -0500
I'm assuming this means that one rule can be used for multiple questions,
and that your data looks like this:
QID, RID, Response
1, 1, Truck
1, 2, Boat
2, 1, Truck
2, 2, RV
3, 1, Truck
3, 2, Motorcycle
Then I would Group By RID & Response to find those with a Count(QID) equal
to the total count of questions. From there, you would use all that info to
query for the QID & RID that make the cut.
I'd do it in about 3 queries or so..
--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html
"mscertified" <rupert@xxxxxxxxxxxxx> wrote in message
news:719846A9-9905-4B48-8949-15B5AA5A4163@xxxxxxxxxxxxxxxx
> With the following table structure:
>
> RuleID
> QuestionID
> Response
>
> There are a fixed number of questions (currently 10) which apply to each
> rule.
>
> For each Question where all of the Responses are the same across all
> Rules,
> I need to list the rules.
> I'd like the output to be a table with 2 columns: Question and Rule
>
> Can anyone think of an efficient way to do it?
>
> -David
.
- Prev by Date: Re: criteria characters
- Next by Date: Re: can i have a querie with a linked table
- Previous by thread: Re: Page numbering in export to PDF
- Next by thread: Re: Query problem
- Index(es):
Relevant Pages
|
