Smitty - thanks for your interest.
I work in the IT department for my county government. Our community has an Equestrian Center and the EQ staff rents horse stalls and RV sites from the field. They currently use a calculator, hand write receipts, return to the office and transfer the data from the receipts to Excel. The proposal is to provide the staff with a Symbol Handheld PDA (with Excel). Collect the data from the field and transfer the data to the desktop in the office.
The staff will need an input form (or equivalent) to collect the rental data. The renter could be charged for several items (stalls, shavings, rv site, grounds fees, misc). I would like the item field to be a drop-down, the unit cost will populate based on the item. The tax and total will be calculated fields.
My question is how to transfer the data from the input form to the excel spreadsheet? If it was only one item it would be easy.
Thanks again - Allison
Receipt #:
Date:
Name:
Item: Quantity: Unit Cost: Tax: Total:
Item: Quantity: Unit Cost: Tax: Total:
Item: Quantity: Unit Cost: Tax: Total:
Item: Quantity: Unit Cost: Tax: Total:
Item: Quantity: Unit Cost: Tax: Total:
Item: Quantity: Unit Cost: Tax: Total:
Total Due:
Payment method: