You have chosen to sponsor your bid up to a maximum amount of .
This project involves the following:
Prompting the user for an input number this number will be 7 or 8 digits in length.
This 7-8 digit number shall be used to pass to 3 separate but related queries. The query results shall be passed and put on a word document template. The template has fields and field labels. The labels will be fixed, but the data the labels identify will be populated by data from the query results. One of the query sets will require logic to separate the data into strings for the word document.
One of the fields shall be the current (the data the document is printed).
A message prompting for “number of cartons in shipment”. This number will be hand typed by the user then passed in the Word document.
The prompts can appear in any order.
Logic shall be written to pull text from between data markers.
CR: AA9999 :XCR RE: 122A94 :XRE DI: 99AQ99 :XDI DP: HQOFFICE :XDP
This data needs to be separated so it can be placed in the word document and be human readable.
Customer Acct Number: AA9999
I have the queries written for this project. Incorporating the query results and the logic to separate the string of text and passing the data to the preformatted word document is what is needed.
You work will need to be supported for one year if the deliverable stops being functional.
Questions are welcomed.