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!
[color="purple"]
Query Needed:
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!

See if any of these help get you started:

My favorite: print different number of labels for each record
See attachment on the second reply

Also:
repeat a record in a report (for example 3 times)

Edited by: HiTechCoach on Thu Feb 28 22:38:37 EST 2008.

Hi Tom

Your structure for what you are trying to achieve is all wrong.

You should have a Table for Clients and another table for Allowance Details.

See the attached reworked example.

Ihave created an Input Form - the query for the labels and the Labelreport

Come back with any questions

Mike

WOW!!! WOW!!!
First Thing – I have been trying to find an example db that shows me how to begin to restructure my data – you just gave me one!
You would probably “cringe” if you saw my actual table for clients – over 150 fields and NOT normalized!
I have real lots – but have not been able to figure the mechanics of the table structure to normalize my data. You just gave me an example that I think I understand! Well at least the table part of it – normalization is another thing.

Second – Your label db attachment looks great!
I don’t have time this morning, but tonight I will dig into it, I’m sure I can apply what you given me to my db.

[b]Third - THANKS FOR TAKING THE TIME TO SHOW ME! This place is great and I have learned so much! But sometimes I just need to see a working example to understand. I really appreciate the help!

Thank you!
Tom

I see you posted an answer back to me last night. Thanks for the help! You have helped me in the past and I appreciate that very much. I printed out the links you gave and will use them to help solve my problem.

Thanks!!

Hi Tom

I would also add another field into into the tblAllowancedetails to record the DateofAllowance.

You would then be able to create a query that would allow you to retrieve All Allowances for a Range of dates

Hopt this helps

Mike

Tom,

I have now had a change to take a look at your database.

I agree with Mike that the issue really comes from your table structure. If you properly normalize the tables, then this would be a simple query to get each label.

If you do not change the table structure, I t can be done by creating a queries and a union query. The problem with this method is that it's more consuming to update the database in the future to add or remove an label.

The links I posted were really for printing the same label or record multiple times. I am not sure how usefuel that will be for what you are needed at the moment.

Taking your advice and I have began the normalization process. I am creating a sample db that will have the same structure and the finsihed normalized db.

If is a learning process for me. I'm sure I am not the first person to start a db and two years later relize that it needs to be normalized to continue.

I appreciate you help!
Tom