Hello,
I am in need of assistance with building an Access query that will display a count of the number of times that a specific number is the leading digit in the Amount column in the attached dataset. For example, I am looking for a query that will tell me the number of times that "1" is the leading digit of the amount, that "2" is the leading digit of the amount, that "3" is the leading digit of the amount, and so on all the way to 9.
I have attached a sample workbook to use with the data in it. Please let me know if you have any questions.
Thanks,
Derek