Group By on first two numbers only...

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

Guest

Hi there,
I'd like to do a Count query where the records are grouped on the first two
numbers in the field.
For example, the Number Field always shows 5 digits so I would like to count
the records for all records beginning with 10, then 11, then 12 and so on.
Can you explain how I might do this?
Many thanks in advance.
Regards,

Lee
 
Hi Baby Face.

Create a new query on the records to show First2dig:Left(numfield,2) this
will show a field with just the first two digits then you can you a query
doing a count. Or what ever else you wan't.
 
Thanks for the quick reply.
That's great!!

Ian B said:
Hi Baby Face.

Create a new query on the records to show First2dig:Left(numfield,2) this
will show a field with just the first two digits then you can you a query
doing a count. Or what ever else you wan't.
Click to expand...
 
Back
Top