Multiple results on query


C

Colm

Please help i have a query designed in design view which select detailsof
name and address and policies for a client.

This is actually an amalgamation of two queries but it is creating multiple
copies of the data. I want only the current address and policies.

the sql view of the query is below. Where have i gone wrong and how can i
fix it.

I am a novice so please explain my error in simple terms.

SELECT [Policies for individual client by ref].ccode, [Client By Ref Current
Address].title, [Client By Ref Current Address].Forname, [Client By Ref
Current Address].Surname, [Client By Ref Current Address].address1, [Client
By Ref Current Address].address2, [Client By Ref Current Address].address3,
[Client By Ref Current Address].address4, [Client By Ref Current
Address].address5, [Client By Ref Current Address].postcode, [Client By Ref
Current Address].tele, [Policies for individual client by ref].contract,
[Policies for individual client by ref].conttype, [Policies for individual
client by ref].polstatus, [Policies for individual client by ref].[Net
Premium], [Policies for individual client by ref].[Life Cover Amt], [Policies
for individual client by ref].value, [Client By Ref Current Address].tele2,
[Client By Ref Current Address].tele3, [Policies for individual client by
ref].matdate, [Policies for individual client by ref].onrisk, [Policies for
individual client by ref].accepdate, [Policies for individual client by
ref].propdate, [Policies for individual client by ref].company, [Policies for
individual client by ref].[CI Cover Amt], [Policies for individual client by
ref].[PHI Benefit], [Policies for individual client by ref].[Deferred Period
(WKS)], [Policies for individual client by ref].[Gross Premium], [Policies
for individual client by ref].lifeass, [Policies for individual client by
ref].val_date
FROM [Client By Ref Current Address] RIGHT JOIN [Policies for individual
client by ref] ON [Client By Ref Current Address].ccode = [Policies for
individual client by ref].ccode
WHERE ((([Policies for individual client by ref].ccode)=[enter Client Ref]))
ORDER BY [Policies for individual client by ref].conttype, [Policies for
individual client by ref].polstatus;

thanks
 
Ad

Advertisements

J

Jerry Whittle

Let's try something simple and see if it works. Change

SELECT [Policies.....
to
SELECT DISTINCT [Policies......
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top