how to stop duplicate valuew

[mattgsh]

I am sort of new to access so I was wondering could this forum help me. I have a table that contains contract fixed billing on a month by month basis Jan, Feb, Mar etc for each account that, never changes. However there is another sheet that contains the actual cost of these bills but these are not by the exact month eg expensese that are between 20/3/2011 and 18/04/2011, this gets updated on a month to month basis. If I Query both these tables in the same query I keep getting duplicate values. This is really annoying because the two tables share fields such as contract number and account number. Is there a solution for this?

 

[Sketchin]

Try displaying the query in SQL and at the beginning, type SELECT DISTINCT, rather than just select.

This MAY work, and if it doesn't, then copy and paste the SQL here so someone can see what your query is doing.