By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,912 Members | 1,723 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,912 IT Pros & Developers. It's quick & easy.

Calculate with Dates in a query with a one to many relation between tables

P: n/a
How to cope with query output which provides all possible values based
on a one to many relationship between two tables. I'm only interested
in one answer per primary key in the 'one' table. I've tryed to filter
out several values, but it does not work (because then also correct
answers are lost) or still 'double' or wrong answers appear. In the
many table, there are records which are not necessary for my query (or
calcultions), but they do result in an additional output record in the
query.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Guido wrote:
How to cope with query output which provides all possible values based
on a one to many relationship between two tables. I'm only interested
in one answer per primary key in the 'one' table. I've tryed to filter
out several values, but it does not work (because then also correct
answers are lost) or still 'double' or wrong answers appear. In the
many table, there are records which are not necessary for my query (or
calcultions), but they do result in an additional output record in the
query.


If your many table has 2 records that meet the criteria, you will have 2
records linking the one-to-many.

You can create a Totals query if you like or, when the query builder is
open, open the property sheet and set the values to Unique.

It appears you are not filtering the Many side correctly.

You might be better off to create a query to select records based on a
filter for the many side. Then create a query for the One side. Then
create a query to link these 2 queries together.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.