Quering the same table twice but getting duplicated data.

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I have a table which shows the maturity dates for deals
done with companies and the exposures for each of those
deals.
I have created two queries.
One queries all the deals between 0 to 5 years and the
second queries all deal over 5 years.
In the first query I get back 30 records which is correct.
In the second query I get back one record 30 times.
There is only one deal which meets the second query
criteria, but the query table fills both answers out side
by side and fills the date and exposure for that one deal
along side the other data.

if anyone can help please do.
thanks
 
In the first query I get back 30 records which is correct.
In the second query I get back one record 30 times.
There is only one deal which meets the second query
criteria, but the query table fills both answers out side
by side and fills the date and exposure for that one deal
along side the other data.
Click to expand...

Please open your query in SQL view and post the SQL text here. I'd
guess you have a join problem but without seeing the query it's all
but impossible to diagnose!
 
-----Original Message-----


Please open your query in SQL view and post the SQL text here. I'd
guess you have a join problem but without seeing the query it's all
but impossible to diagnose!


.
Click to expand...
Here the SQL text.
SELECT deal_tic.MAT_DATE, deal_tic.NBV,
deal_tic_1.MAT_DATE, deal_tic_1.NBV
FROM deal_tic, deal_tic AS deal_tic_1
WHERE (((deal_tic.MAT_DATE)<DateAdd("yyyy",12,Date())) AND
((deal_tic_1.MAT_DATE)>DateAdd("yyyy",12,Date())));

Thanks for the help
 
Back
Top