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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bimal13

    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
  2. bimal13

    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
  3. bimal13

    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...
  4. bimal13

    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...
  5. bimal13

    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...

Part and Inventory Search

Back
Top