Show Bid Request
Update Query in Access
Bid Request Id: 28842
|
|
|
|
Posted by: |
GTE (6 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 11.11%
|
|
Posted: |
Sep 26, 2002
5:53:47 PM EDT
|
|
Bidding Closes: |
Sep 28, 2002
5:59:37 PM EDT
|
|
Viewed (by coders): |
341 times
|
|
Deadline: |
9/29/2002
TIME EXPIRED
|
|
|
|
|
Description:
I am in need of an update query that will look in one column within a table and if that column does NOT contain a valid year I want to be able to choose betwen a first choice, second choice or third choice a year to be placed there. I need this as soon as possible and am will give bonuses based on turnaround and the actually performance of the query.
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:
windows nt/xp
Must be 100% finished and received by buyer on:
Sep 29, 2002 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Special Conditions / Other:
It would be ideal to have this query within 12 hours. But, no later than 09/27/02 at 9a.m. I will reward generously via bonus for the immediate turnaround.
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 |
|
|
|
|
N/A
|
Sep 27, 2002
1:22:05 AM EDT
|
10
(Excellent)
|
|
|
Hello,
My name is Richard Ryerson. I am a Senior Developer with over 7 years experience developing custom solutions.
I have to tell you what you are asking is really unfeasable for several reasons. First of all, update queries are atomic, meaning that if something adversely, such as a cancel, happens after 1000 records have been updated (within page size) the whole thing is rolled back. Secondly, unless the table only contains a MINIMUM amount for invalid years, that this method would be right. (Imagine being prompted 10,000 times if the query find 10,000 records with invalid dates) Third, how are you planning to determine the correct year? In an update query that prompts you, you will not be able to see any of the data pertaining to that particular record. (Absolutely NOT possible)
On a more promising note, here are a few things for you to ponder.
1. If there is a way, anyway at all, that we can determine the correct date from the record, we can use that to update the data. No user intervention besides a confirmation involved.
2. If not, I can deliver you a custom application that will present you the incorrect data and allow you to make the changes in a list / grid style. (I would use VB 6 probably or create an Access form it fit well)
3. How is the data formatted? Is this year field an integer, a 2 or 4 digit text, part of a larger sized text field or is it inserted in a memo field?
In closing, if you can answer me these questions, I am prepare to make a bid of $25.00 for the update query (considering good database design and we can hash out a method to determine the correct date) or I will bid $75.00 for a custom app / Access form for the grid / list style update 'method.'
Best regards,
Richard Ryerson |
|
|
|
|
|
|
