Search results

  1. D

    Hide duplicate data across entire report

    Hello, How do I remove duplicate records from a report accross the entire report? According to the Access help I can only remove duplicate records from each page using 'Hide Duplicates'. Any suggestions? Thanks, Derek Basch
  2. D

    DISTINCT predicate and multiple fields

    Hello, I am trying to do a query such as: SELECT DISTINCT [Qualified Leads].[Company], [Qualified Leads].[Record Creator] FROM [Qualified Leads]; This returns all of the records that have fields taht are a combination of unique values. However, what I really need is just the company field to...
  3. D

    Iif Counting

    Hello, I am using a summed Iif statement to count the number of occurences of a specific field value in a report. In this case Yes/No. I am using the below statements in 2 text boxes to total the Yes and No answers: =Sum(IIf([Qualified]=No,0,1)) =Sum(IIf([Qualified]=Yes,1,0)) The totals...
Back
Top Bottom