Blocks or singles qty less then 10 Report
Project details
I need a new access 2000 report created then added to the main menu as a button to run the report.
The report needs to sort the data base by the field “Country” and “Pick #” reporting only those “Pick #” where the “Total Notes” quantities are less than or equal to the number 10. If a number 10 or less is found then all identical “Pick #” that are in the inventory need to be in the report even if the “Total Count” exceeds 10.
A “Pick #” can appear in inventory more than once. As individual items, or in blocks (sheets).
Example Pick # 16a can appear three times in inventory. Once as singles indicated when the “Blocks” field is empty. Once as a block of five indicated as “B of 5” in “Blocks” field. Again as a “B of 6” also indicated in the blocks field. If any of the 3 identical “Pick #” has a “Total Notes” count that is equal to or less than the number 10 then all 3 identical “Pick #” need to appear in the report.
The option to print the report to screen or printer is necessary
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer’s environment–Deliverables must be installed by the Seller in ready-to-run condition in the Buyer’s environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered “work made for hire” under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder’s Seller Legal Agreement).
## Platform
Report needs to run in Microsoft Access 2000. The entire database will be provided. (about 757k zipped). The operating system is Windows XP Professional
Awarded to:
Maureen G.
(5.0)
Project budget: $25.5 USD
budget limits: $30-100 USD
number of bids: 12
average bids: $55
Awarded to:
Maureen G.
(5.0)
Project budget: $25.5 USD
budget limits: $30-100 USD
number of bids: 12
average bids: $55
Project details
I need a new access 2000 report created then added to the main menu as a button to run the report.
The report needs to sort the data base by the field “Country” and “Pick #” reporting only those “Pick #” where the “Total Notes” quantities are less than or equal to the number 10. If a number 10 or less is found then all identical “Pick #” that are in the inventory need to be in the report even if the “Total Count” exceeds 10.
A “Pick #” can appear in inventory more than once. As individual items, or in blocks (sheets).
Example Pick # 16a can appear three times in inventory. Once as singles indicated when the “Blocks” field is empty. Once as a block of five indicated as “B of 5” in “Blocks” field. Again as a “B of 6” also indicated in the blocks field. If any of the 3 identical “Pick #” has a “Total Notes” count that is equal to or less than the number 10 then all 3 identical “Pick #” need to appear in the report.
The option to print the report to screen or printer is necessary
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer’s environment–Deliverables must be installed by the Seller in ready-to-run condition in the Buyer’s environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered “work made for hire” under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder’s Seller Legal Agreement).
## Platform
Report needs to run in Microsoft Access 2000. The entire database will be provided. (about 757k zipped). The operating system is Windows XP Professional
The report needs to sort the data base by the field “Country” and “Pick #” reporting only those “Pick #” where the “Total Notes” quantities are less than or equal to the number 10. If a number 10 or less is found then all identical “Pick #” that are in the inventory need to be in the report even if the “Total Count” exceeds 10.
A “Pick #” can appear in inventory more than once. As individual items, or in blocks (sheets).
Example Pick # 16a can appear three times in inventory. Once as singles indicated when the “Blocks” field is empty. Once as a block of five indicated as “B of 5” in “Blocks” field. Again as a “B of 6” also indicated in the blocks field. If any of the 3 identical “Pick #” has a “Total Notes” count that is equal to or less than the number 10 then all 3 identical “Pick #” need to appear in the report.
The option to print the report to screen or printer is necessary
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer’s environment–Deliverables must be installed by the Seller in ready-to-run condition in the Buyer’s environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered “work made for hire” under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder’s Seller Legal Agreement).
## Platform
Report needs to run in Microsoft Access 2000. The entire database will be provided. (about 757k zipped). The operating system is Windows XP Professional
Skills: EngineeringExcelMicrosoft AccessMicrosoft ExchangeMySQLPHPPowerpointSoftware ArchitectureSoftware TestingWord
Some Maureen G. projects
| Project Title | Skills required in the project |
|---|---|
| Blocks or singles qty less then 10 Report | Engineering Excel Microsoft Access Microsoft Exchange MySQL PHP Powerpoint Software Architecture Software Testing Word |
| Small Access problem | Engineering Microsoft Access MySQL PHP Software Architecture Software Testing |
