Show Bid Request Small Access 97 Query/Function Bid Request Id: 75799 Bookmark in my 'To Do' list Posted by: Wampy1 (39 ratings) (Software buyer rating 10) Non-action Ratio: Above Average - 28.33% Buyer Security Verifications: Excellent Approved on: Jul 29, 2003 1:07:16 PM EDT Bidding Closes: Aug 12, 2003 1:06:26 PM EDT Viewed (by coders): 52 times Deadline: 7/30/2003 1:31:48 PM (1 days after 7/29/2003 1:31:48 PM) Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Database, Access Enter chat room for this bid request (0 active users at Sep 13, 2003 3:00:19 AM EDT) Description: I need an update function written for an Access 97 DB. The DB has a table called dbo_imitimidx_sql. Each record has a TEXT field called "upc_cd" which is just a number, like "80738510772". I need a function to perform the following, scan the table for any record where the field "mat_cost_type"='F' to assign the next sequential number to the UPC_CD field. Here is an example : item_no mat_cost_type upc_cd Item1 F 80738510833 Item2 F 80738510832 Item3 F [null] Item4 W [null] Item5 F [null] So this function should assign a UPC code of 80738510834 to Item 3 and 80738510835 to Item 5. It should Not assign a UPC Code to Item3 since its mat_cost_type <>"F" . I am attaching a small sample database. Please note the actual table has over 11,000 records. Thank you, Steve 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 97 ! 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! Oleg Kreslavsky (20 ratings) in Zaporozhye, Zaporozhye Ukraine Bid id: 818,435   $15 (USD) Jul 29, 2003 1:24:45 PM EDT  9.5 (Excellent)     Hello, Steve! I can complete this for one hour. In other words, you will receive the function almost immediately after your acceptance of my bid. Best regards, Oleg.           There are 4 private replies to/from Oleg Kreslavsky. Click here to view them.