Hi, I have a query with approximately 100 criteria. That is a bit much, thus I have made a table of the criteria and in the query a relation laid to this table. The criteria are countries with an increased risk on tbc. I point these query on a column with parent 1 and afterwards on the column with parent 2. Then I want the results from both query's in a table, but without double rows. I have tried this with a merge query but these only give the results where the hits for parent 1 and parent 2 are the same. This is by far not always the case, so, I miss all hits where there would be a hit for one parent only. Cumbersome tale, but perhaps there is someone who understands what I mean?
unique results of two relational query's
- Thread starter Erik Murk
- Start date
Ron_dK
Cool bop aficionado
- Local time
- Today, 23:38
- Joined
- Sep 5, 2002
- Messages
- 2,129
Erik,
Having looked at your Dbase, it is clear that your design has flaws.
Do a search for normalization on this forum and redo the Dbase with appropriate tables and queries. Your current design is spreadsheet based and if I understand your question, you will never achieve what you're asking.
As far as I can see , you might set up three tables :
One for countries
one for parents data
one for childrens data
Once done , you can set the appropriate relationships and design queries, based on the data in the relevant tables.
Succes
Having looked at your Dbase, it is clear that your design has flaws.
Do a search for normalization on this forum and redo the Dbase with appropriate tables and queries. Your current design is spreadsheet based and if I understand your question, you will never achieve what you're asking.
As far as I can see , you might set up three tables :
One for countries
one for parents data
one for childrens data
Once done , you can set the appropriate relationships and design queries, based on the data in the relevant tables.
Succes
Similar threads
