Problem: How do I print one label or multiple labels for each client depending on how many times they get money each week?
I am a social worker and we hand out cash money to our clients each week. Some clients get money once per week while others get money two or three times per week. It is possible that one client might need five labels!
I have a working database that we have been printing out these labels for over a year. When we need more than one label we hand write it – bummer!
Once per week I want to print lables. For each day that that a client gets an allowance I want to be able to print out that many labels. Printed on the label there needs to be that day’s allowance amount and also the day of the week it is to be delivered.
I’m sure this is easy for some of your smart Access gurus our there, but I have not been able to learn how to do this for over a year!
Attached is a stripped down version of the db with all the confidential information removed. I have left only five clients in the db, but those five have their allowance intervals set to show you what I am looking for.
As always thanks for teaching be how to do something new!