Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
reg. running query
sorry Leslie. I am new to this site. I dont see any query which you posted in replu to my thread.Please let me know how to access it. Bimal- bimal13
- Post #7
- Forum: Microsoft: Access Other topics
-
reg. running query
Hi Leslie, This is the same query as given in the thread181-1426975: reg. removing duplicates with latest date and unique member ID No, I could not get an answer to this query with what I tried. What I tried is posted in my second thread. Thanks Bimal- bimal13
- Post #5
- Forum: Microsoft: Access Other topics
-
reg. running query
Hi Leslie, Thankyou for your reply. The query is not able to sort by the latest date of service(dos) and is not able to filter out the member_id field for unique records.It should retain the record with the latest date of service(dos)in the event of a duplicate member_id and duplicate...- bimal13
- Post #3
- Forum: Microsoft: Access Other topics
-
reg. running query
In regards to my first thread, I am currently working in MS Access and running an SQL query in MS access.This is how my query is: SELECT analname,member_id,member_name,dob,sex,max(dos),spec_num,smc,testname,dxcode1,loinc,ndec_low,ndec_hi,rslt_dec,abn_code...- bimal13
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
-
reg. removing duplicates with latest date and unique member ID
I currently have a table with these fields: analname,member_id,member_name,dob,sex,dos,spec_num,smc,testname,dxcode1,loinc,ndec_low,ndec_hi,rslt_dec,abn_code, rsltabrv,cpt_code,pay_acct,acctname,elig_sw,ord_acct,docname I would like to have a query that will show all these fields without any...- bimal13
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
