showing duplicate records

A

ACSer

i am trying to create a query that returns a report that is showing data from
4 tables. on one of the tables there are possibly two records for the same
event. i am trying to show the latest and greatest and using max on the
letter date but no luck. Any Suggestions?

SELECT Max(REFUND_LETTERS_SENT.LtrDate) AS LtrDate,
REFUND_LETTERS_SENT.PaidDate, REFUND_LETTERS_SENT.Amount,
REFUND_LETTERS_SENT.Notice, REFUND_POSTINGS.Claim_Number,
REFUND_POSTINGS.Ini_Rcpt_Source_ck_log, REFUND_POSTINGS.Check_Date_ck_log,
REFUND_POSTINGS.Check_Amount_ck_log, REFUND_POSTINGS.Provider_ck_log,
REFUND_POSTINGS.Solicited_ck_log, CELTIC_AUDIT.Source_Identifier_CELTIC,
CELTIC_AUDIT.REFUND_DUE, CELTIC_AUDIT.DATE_REFUND_RCVD, CELTIC_AUDIT.STATUS,
CELTIC_AUDIT.FINDINGS, CELTIC_AUDIT.AUDITORS_COMMENTS,
CELTIC_AUDIT.ACS_REBUTTAL, CELTIC_AUDIT.CELTIC_FINAL_COMMENT
 

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

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
query to show where no data in a stated column 0
Creating a Chart on form from selected data in query. 0
Adding data to MS Access from csv file 0
Query the same table three times 0
show the most recent payment 8
Greatest date per Unit 3
Query to select individual records 4

Top