UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> LABELS - Print One or Multiple – HOW?    
 
   
TomTessa
post Feb 28 2008, 10:15 PM
Post #1

UtterAccess Addict
Posts: 264
From: Grand Rapids, Michigan



Problem: How do I print one label or multiple labels for each client depending on how many times they get money each week? (IMG:http://www.utteraccess.com/forum/style_emoticons/default/crazy.gif)

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!

Attached File(s)
Attached File  LabelProblem-Tom02292008.zip ( 33.07K ) Number of downloads: 2
 
Go to the top of the page
 
+

Posts in this topic


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 07:36 PM