Recent content by Atenti

  1. A

    Help needed with a select query

    Hi All, Our IT department made a select query long time ago in excel and my client wants me to add another field name from the sql server. The field name is "client_status" from database "Reporting" table named "SXD_Client". Here is the query: SELECT DISTINCT (svl.omr_fk_metric_id) AS...
  2. A

    I need to delete duplicate records, but with a specific criteria

    Hi Folks, I have a query which is pulling some duplicate records from the database. I need the duplicate data to be removed , but i also found out that sometimes one field which is called "URL" has data and when i delete the duplicates i need to keep the record with the URL data. It might be...
  3. A

    Help needed. Overall rating for 7 questions based on company ID

    Hi All, I have been following the forums here for quite some time , but i finally managed to register today and i need fellow forum members advice on an issue i am having with one access query. I am having the following database setup: Client_id Respondent_Name Company_id Question 1 Question...
See more
Back
Top Bottom