You know, theres a reason that they say "always attach whatever you  
want before writing the email," and I just figured that reason out.  
Attaching resume now.

-Tristan


Quoting Joshua Payne <[log in to unmask]>:

> Hey CSSA,
> I've been in contact with a small business owner who needs some
> database work done. It looks pretty straightforward and would be a
> quick way to make a buck (500 of them, actually). Read below and let
> me know if any of you (or anyone you know) is interested. Note: this
> isn't a "I've always wanted to learn database design" type of thing.
> If you are good at this stuff, then you are who this guy is looking
> for. Otherwise, not.
>
> Contact me if interested and I'll relay the message on.
>
>> I am looking to build a database that will track the sales that my   
>>  team makes per address. needs to be able to track it by rep, by    
>> address, and I need to know what product (one of three) was sold    
>> and when. this is important as I am not allowed to sell the same    
>> product to the same address within 90 days.
>>
>> so really what I need is a database that can track the address of    
>> my clients, the date they were last serviced, and tell me if the    
>> date I am entering (today) is within 90 days of their last service   
>>  (for that particular product). I CANNOT charge for service if I    
>> have serviced the same address within 90 days. so if I can enter    
>> the address and date and hit save or whatever, then a red flag come  
>>   up and says address was serviced within 90 days, cancel. or a   
>> green  flag pops up and says address has NOT been serviced within   
>> 90 days,  place order.
>>
>> The data I would like to track Is:
>>
>> Customer Name
>>
>> Street Address (might need to use the zip also as you know there    
>> are main streets everywhere...so if I do 123 main sty, I may have    
>> that same address in 9 different towns...)
>>
>> zip
>>
>> Phone number
>>
>> ID# (social)
>>
>> Rep name
>>
>> Cable service (yes no checkbox)
>>
>> Date of Install
>>
>> Internet (yes no)
>>
>> Date of Install
>>
>> Phone Service (yes no)
>>
>> Date of Install
>>
>> If it is possible, after I do what I described above, I would like   
>>  to be able to sort the data and find out which rep is trying to    
>> sell these jobs within 90 days so I can yell at them. is it    
>> possible to keep a "history" of the address so I can see that it    
>> was sold service 9 times this year or something similar?
>>
>>
>>
>>