Customer Database

[Porritt, David]

I use Access for my database of pianos at the school.  I also have a
date for 'next tuning due'.  It is a calculated field based on the 'last
tuned' field and the 'times per year' field so it's automatically
calculated when the 'last tuned' field is updated.  So if a piano is
scheduled to be tuned 4 times per year it adds 365/4 days to the 'last
tuned' field.  Then I have a query that looks for 'next tuning due'
fields that are either already past or will show up in the next 14 days
and it prints me a list.  

 

A real database program like Access is the most complete way to go about
data storage though admittedly it is more complex to set up.

 

dave

 

 

David M. Porritt, RPT

dporritt at smu.edu <mailto:dporritt at smu.edu> 

 

From: pianotech-bounces at ptg.org [mailto:pianotech-bounces at ptg.org] On
Behalf Of Piano Boutique
Sent: Saturday, April 12, 2008 11:21 AM
To: Pianotech List
Subject: Re: Customer Database

 

Michelle,

 

I use Microsoft Access and have a field for next tuning.   If the
reminder should show up for May:  I enter it as; 2008-05

 

When May does arrive, I Sort on the next tuning for 2008-05 and only
have those reminders that should show up.

 

William

 

 

 

 

PIANO BOUTIQUE
William Benjamin
The tuner alone,
Preserves the tone.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://www.moypiano.com/ptg/pianotech.php/attachments/20080412/a9d5acd8/attachment-0001.html