multiple results

[slimjen]

All; using access 2010. I have a problem with queries that joined tbls with date fields. If I have a tbl with a cust record joining to a tbl with dates it inflates my result because it originally has two records without grouping. How can I get around this?

[ItsMe]

If the Cartesian Product is unavoidable then I believe the best solution is GROUP BY.
http://www.dba-oracle.com/t_garmany_...cross_join.htm

[JoeM]

It sounds like you have a one-to-many (or many-to-many) relationship between tables. Addressing that really depends on what the data looks like, how the tables are joined, and what you want to return. I think we will need those details in order to give you specific direction.

[slimjen]

I have the tblcust left joined with tbltermed and the query is grouped. I can use a max on term but have run into problems where the user doesn’t necessarily want the max or min.

[JoeM]

Please show us sample of the data in each table, and what you would like your expected outcome to look like.
Before we can tell you "how to get there", we need to know "where we are going".