Show Bid Request
Quick MS Access Help Needed
Bid Request Id: 29938
|
|
|
Description:
I need a coder to write a Module and Query in MS Access 2000 that will take a field and depending on its content modify it, removing extra charactors within the field.
Here is a list of some samples of the fields now:
________________________________________________
3 Certificates 7.49; C1 Bastard Boss 0.00 7.49; C2 Bitch Of the Year 0.00 7.49; C3 Ass Kisser 0.00
3 Gift Certs 2.99; Gift Cert # 1 Dr.Kervorkian 0.00 2.99; Gift Cert # 2 One Nation Under God 0.00 2.99; Gift Cert # 3 Martha Stewart 0.00
Smasher Combo - 21.89; Smasher # 1 BaseBall 0.00 21.89; Smasher # 2 Golf Ball 0.00
3 B-Stickers - 4.89; Bumper Sticker # 1 Hang Up and Drive 0.00 4.89; Bumper Sticker # 2 PETA 0.00 4.89; Bumper Sticker # 3 My Kid Kicked The Crap 0.00
3Weenies- 34.67; Weenie Baby # 1 PEPE The Pig 0.00 34.67; Weenie Baby # 2 DING A LING LING the Panda 0.00 34.67; Weenie Baby # 3 ICE PUBE the Polar Bear 0.00
3 Prank Envelopes 4.29; Envelope # 1 HotDogs are Great 0.00 4.29; Envelope #2 Ring My Telephone 0.00 4.29; Envelope # 3 Summer Is Not Winter 0.00
Combo - 3 Pack of Magnetic Gag Signs 9.49; Bumper Gag # 1 Ring My Bell 0.00 9.49; Bumper Gag # 2 I eat Taco Salad 0.00 9.49; Bumper Gag # 3 Young and The Wrestless 0.00
________________________________________________
Here is how I would like them to appear :
3 Certificates - Bastard Boss, Bitch of The Year, Ass Kisser
3 Gift Certficates - Dr. Kervorkian, One Nation Under God, Martha Stewart
Smasher Combo - BaseBall, Golf Ball
3 B-Stickers - Hang Up and Drive, Peta, My Kid Kicked The Crap
3 Weenies - PEPE The Pig, DING A LING the Panda, ICE PUBE The Polar
3 Prank Envelopes - Hot Dogs are Great, Ring My Telephone, Summer is Not Winter
Combo - 3 Pack of Magnetic Gag Signs - Ring My Bell, I Eat Taco Salad, Young and The Wrestless
________________________________________________
As you can see it appears a ; seperates the fields, but I want all the 0.00 and 7.49's etc removed.
You can not hard code the 3 options as they will change. For instance in the last example, there are 10 different Magnetic Bumper Signs that could be listed, but only 3 at any one time.
I would like a working query and the code for the module.
I need as soon as possible.
First bidder to bid with working a working sample wins the project. You can see by my feedback, I am an honest buyer.
Deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
Platform:
Access 2000
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
This bid was accepted by the buyer!
|
$10 (USD)
|
Oct 5, 2002
7:59:08 PM EDT
|
5.81
(Above Average)
|
|
|
| Hey This is a simple VBA script. Let me know I can finish it in 1 hour. Let me know. |
|
|
|
|
|
|
live RSS newsfeeds