selecting records

[Rockape]

Hi all,

Before i explain my problem, please note that i have posted a similar thread in the queries forum.

I hope i'm not offending anyone!

My problem is this:
I have a table with payments made to sundry payees. I've made a simple query which groups the payees. However I would prefer to see just one of the recurring payees. i.e if jblogg appears twice in the query result, i would like to see him only appear once.

Regards
If i have not explained myself plz let me know

 

[maxmangion]

not sure if i understood your question correctly, but try adding the word DISTINCT in your SELECT statement of your query i.e. SELECT DISTINCT etc

 

[Rockape]

Hi ,

Thanks for your reply.

What i want to do is:

I have a table of records ( of payees) some of which may appear twice, eg jblogg £10 , jblogg £17,Another £23 etc.

At the end of the day i want to extract from a list of records of payees, where jblogg only appears once irrespective whether he's been paid twice or more.

Regards

 

[namliam]

Do you want to see the amount seperately? Or total ? Or not at all?

Because the amount is causing the 'duplicate' Payees.

P.S. You really should post a question only once!

 

[Rockape]

Hi,

Sorry if i've offended anyone for posting the question twice.

Anyhow, the answer to your question is not at all. Say for example, the record may hold other data, but I want my query to only display all the payees only once even if they have been paid twice or more.

Thanks

 

[namliam]

Just take your group by query and remove the amount... that should "single out" the payee's

 

[Rockape]

Hi,

Done that, but I still get jblogg repeated many times. Perhaps I'm not explaining myself properly.

Regards

 

[Rockape]

Hi Mailman,

Thanks it worked !!! Thanks again (sometimes it is easier than expected)

kind regards