1
  • how to perform a distinct count on a record over 2 sub reports

    hi all, i have a report returning list where it is grouped by city. it contains fields: ID (each record has unique id), serial(each client will have a serial to idenfy a person)group1 (A<B<C<D) and group2(A<B<C<D)and group date each client can have multiple entries based on how...

    N7865 pointsBadges:
  • SQL query to select highest test score

    I am writing a sql to bring someone's highest test score into a table. The sql is bringing in the highest test score possible, rather than the person's test score. I assume MAX is making that happen. If I take MAX out, it returns the single row subquery returns more than one row error. What can I...

    Cmyers40 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following