Expressions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need some help quick if possible. I have several Spreadsheet's comming my
way. Please don't ask, but there is going to be one for each client at
approx. 400 total. Anyway, I'm thinking of pulling all into access. Reason
is I need to run a count on those clients with a number equal or greater
then 1 via the 2 to 5 column and a count for those equal to or greater theN 1
via the 5 plus column.

Can I get help writing the expression for each please. Thanks.

Clinet Fund Account # EE 2 to 5 5 plus
147 97 319821625 35 196673 0
147 97 331828072 25 36072 0
147 97 318804973 2 6 25000 0
 
I need to run a count on those clients with a number equal or greater then
1 via the 2 to 5 column and a count for those equal to or greater theN 1 via
the 5 plus column.
Please explain it again in a different way.
What is counted for the client?
What are you looking at to be greater than 1?
 
Sorry, I need a count by client of all accounts that hold a dollar value via
the 2 columns indicated "2 to 5" and "5 plus". I don't even need the detail
only a summary by client providing me with the total number of records that
again hold a dollar value.
 
Back
Top