 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / May 2005settiing up clients on a 6 month schedule
I am new to access I have clients that I need to see every six months. I would like the program to tell me who is due for a tune up six months after their last one. I keep track of their address and email what was done on their tune up. I have looked for a template with no luck. How do you track their last one? Is everyone due in six months or will this ever vary for anyone? Could you share some table and fields?  SignatureDuane Hookom MS Access MVP >I am new to access > I have clients that I need to see every six months. I would like the > program > to tell me who is due for a tune up six months after their last one. > I keep track of their address and email what was done on their tune up. > I have looked for a template with no luck. TCG, Let's say you have a TuneUps table, with the ClientID and the TuneUpDate. You can make a query based on this table. Add both fields to the query design grid. Make it a Totals Query (select Totals from the View menu in query design view). In the Totals row of the ClientID column, leave it as Group By, and under the TuneUpDate column, put Max in the Totals row and in the Criteria, put... <DateAdd("m",-6,Date()) You can then base a form on this query, which will show those clients whose last tune up was more than 6 months ago. SignatureSteve Schapel, Microsoft Access MVP > I am new to access > I have clients that I need to see every six months. I would like the program > to tell me who is due for a tune up six months after their last one. > I keep track of their address and email what was done on their tune up. > I have looked for a template with no luck. It would be better if it just showed the clients that were due for a tune up 6-7 months ago, if it shows more than than it would be to confusing. > TCG, > [quoted text clipped - 14 lines] > > I keep track of their address and email what was done on their tune up. > > I have looked for a template with no luck. TCG, In that case, as Duane suggested, you will need to define what you mean by "due for a tune up", and how you know when it is due. I assumed your original meaning was that a client is due for a tune up 6 months after their last one, but it now appears I misinterpreted. SignatureSteve Schapel, Microsoft Access MVP > It would be better if it just showed the clients that were due for a tune up > 6-7 months ago, if it shows more than than it would be to confusing. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.