I want to work Denomination for payroll with Access,
i have data of employees with their salary, so what i want is how much of 100,50,20,10,5,& 1 dollar has one employee taking his salary inconsideration,
for example i salary X, is 120, so he has 1 of 100 , 0 of 50, 1 of 20,
the result will be
Name of employee Salary /100 /50 /20 /10 /5 /1
Daniel 120 1 0 1 0 0 0
Asmerom 50 0 1 0 0 0 0
Jhone 231 2 0 1 1 0 1
Total 401 3 1 2 1 0 1
Thank u very much