Eliminate duplicate records

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi all,

I have FORM link to a QUERY, which I could choose the criteria for searching,
however, hinder by 1 field. The query code as follow:

SELECT DISTINCT studentinfo.sid, studentinfo.slname, order.orderid, wat.
pcfprint, receipt.paid
FROM studentinfo INNER JOIN ([order] INNER JOIN (watusa INNER JOIN receipt ON
wat.orderid=receipt.orderid) ON (order.orderid=wat.orderid) AND (order.
orderid=receipt.orderid)) ON studentinfo.sid=order.sid;

Since in the table of RECEIPT, it might have several RECEIPT NO for 1 ORDER,
some of them may have PAID or UNPAID.

If I specify the SEARCH PAID or UNPAID, it would not have problem, however,
If I perform the search without concerning being PAID or UNPAID, it would
comes out 2 records, with same ORDERID, but 1 is PAID and other UNPAID.

For me, it is a DUPLICATE record, since I only need to SEARCH other Criteria,
e.g. wat.pcfprint = false without concerning PAID or UNPAID.

Could anyone help, how to eliminate the duplicate, instead only show either
PAID or UNPAID?

Thanks in advance!!!!!

--
I am so new to Access... questions questions and questions...

Thanks always!

Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: What are we doing?
    ... activity, paid or unpaid' outside our employment, without declaring ... that activity to our employer. ... It's the "paid or unpaid" bit that is puzzling. ...
    (alt.usage.english)
  • Re: and / or function
    ... all current period accruals + old unpaid accruals. ... invoices are re-accrued in the current period. ... and the paid date is less than F1 OR if its A:A value is less ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Regarding a 1 hour unpaid break
    ... available 5 hours per week on the premises unpaid. ... My employer is insisting that ... I stay for a dinner break and not to be paid for it as well. ... the employer would be in breach of the the WTD if he ...
    (uk.legal)
  • Re: Counting rows
    ... NUMBER" through the next cell containing "PAID STATUS"? ... ASSESSMENT NO 001310350-1 TAX YEAR 2008 TAXABILITY CD 0-00 ... PAID STATUS UNPAID ...
    (microsoft.public.excel.programming)
  • Re: Plusnet slag off other companies
    ... be permitted to write 'criteria is', but surely Comms people are paid to ... You should understand that helpdesk work is low paid and un-glamorous, ... The title 'Comms' is what set me off. ...
    (uk.telecom.broadband)