Hello Alphaholics.
I hope that is the correct salutation, my apologies if I error.
I am in need of simple data base and 1 report. (I think)
I own a messenger service where my customers call my CSR�s and order delivery service. They tell us the company name to pick up from and the company name of where it is to be delivered. They also specify one of four levels of service, or time sensitivity.
I need to historically enter the service request in a table or set? The fields would be,
1. Date
2. Callers Name
3 Account #
4. Pick Up Company (name)
5 Delivery company (name)
6 Service Level
A) Regular
B) Bag Rush
C) Rush
D) One hour
I need to generate a report grouped by account # and give a total for each level of service.
Ex:
(Group Header- Change in Acct # starts new page and repeats on each page)
Account # 210 Regular 65 Bag Rush18
Rush 37 One Hour 7
(Detail Section 6 columns)
Date, Caller, Account#, Pick Up From, Deliver To , Service,
05/05/08, Cathy, 210, ABC Company, Cathy 210,Rush
Field Rules
Date,
Previous value by default is OK (A5 V1 allowed Control D to fill previous value gone now?)
Caller
No rule
Account #
Always Required
Pick Up Company
Previous Value, Allow any/ fill only on popup
Delivery Company
Previous Value, Allow any/ fill only on pop up
Service Level
Simple List, of the four options?
Is there an Alphaholic who can provide me with the described DB & Report?
I am aware there are many considerations to improve the detail and reporting aspects of this project. I created the same result (report) many years ago with A5v1 and my customers are accustomed to the format, therefore I need not deviate form its simplicity.
For some reason I do not seem to have the drive or brain power to get this done, again, so I ask the community to help. I spoke with one �expert� already who estimated 2 to 3 days to complete this DB. Oh really?
Please contact me either via this board or by E-Mail or calling my toll free # with
Any questions you may have,
A time frame for completion
An estimated cost and Payment Options, Pay Pal, credit card, Invoice/company check.
Thank you for your time and assistance
A wannbee Alphaholic
Oscar
[email protected]
T n� T Messenger
Tucson, AZ
877-321-1213
P.S If this soliciation is out of line please accept my apologies.
I hope that is the correct salutation, my apologies if I error.
I am in need of simple data base and 1 report. (I think)
I own a messenger service where my customers call my CSR�s and order delivery service. They tell us the company name to pick up from and the company name of where it is to be delivered. They also specify one of four levels of service, or time sensitivity.
I need to historically enter the service request in a table or set? The fields would be,
1. Date
2. Callers Name
3 Account #
4. Pick Up Company (name)
5 Delivery company (name)
6 Service Level
A) Regular
B) Bag Rush
C) Rush
D) One hour
I need to generate a report grouped by account # and give a total for each level of service.
Ex:
(Group Header- Change in Acct # starts new page and repeats on each page)
Account # 210 Regular 65 Bag Rush18
Rush 37 One Hour 7
(Detail Section 6 columns)
Date, Caller, Account#, Pick Up From, Deliver To , Service,
05/05/08, Cathy, 210, ABC Company, Cathy 210,Rush
Field Rules
Date,
Previous value by default is OK (A5 V1 allowed Control D to fill previous value gone now?)
Caller
No rule
Account #
Always Required
Pick Up Company
Previous Value, Allow any/ fill only on popup
Delivery Company
Previous Value, Allow any/ fill only on pop up
Service Level
Simple List, of the four options?
Is there an Alphaholic who can provide me with the described DB & Report?
I am aware there are many considerations to improve the detail and reporting aspects of this project. I created the same result (report) many years ago with A5v1 and my customers are accustomed to the format, therefore I need not deviate form its simplicity.
For some reason I do not seem to have the drive or brain power to get this done, again, so I ask the community to help. I spoke with one �expert� already who estimated 2 to 3 days to complete this DB. Oh really?
Please contact me either via this board or by E-Mail or calling my toll free # with
Any questions you may have,
A time frame for completion
An estimated cost and Payment Options, Pay Pal, credit card, Invoice/company check.
Thank you for your time and assistance
A wannbee Alphaholic
Oscar
[email protected]
T n� T Messenger
Tucson, AZ
877-321-1213
P.S If this soliciation is out of line please accept my apologies.