Show Bid Request datashaping with dates. Date and records placed on that date.... Bid Request Id: 43207 Bookmark in my 'To Do' list Posted by: salv (5 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Good Approved on: Jan 11, 2003 2:00:22 PM EDT Bidding Closes: Jan 25, 2003 2:21:16 PM EDT Viewed (by coders): 90 times Deadline: 1/25/2003 2:31:16 PM TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Personal Project / Homework Help Bidding Type: Open Auction Categories: Database, Language Specific, ASP, Access Enter chat room for this bid request (0 active users at Jul 12, 2003 10:35:02 AM EDT) Description: I need the following output using ASP/VBScript/MS Access. Todays date (i.e. 11th Jan 2003) Record 999 Record 998 Record 997 {record numbers are for example } Record 996 ' i.e all records added today Yesterdays date (i.e. 10th Jan 2003) Record 995 Record 994 Record 993 Record 992 ' i.e all records added yesterday ......and so on for the last 31 days......... ***100 records must be displayed per page *** For an example of exactly the kind of thing i need please please see http://www.craigslist.org/sfo/bar/ I think this can be done with datashaping but any way is fine as long it it easily transerable to other similar pages. I dont want thirty odd recordsets on one page! Ideally id like to do this from one table (can you shape from one table?) but two or more would be fine as long as i can get the desired output. Iv attached a stripped down database with three rough tables but no data to give a rough idea of the database design and relationships. The relationships are not set in stone yet but will be similar to the customer > record/ad relationship in the sample database. Essentially, what i need is one page in ASP/VBScript with a database similar to the one supplied which has an output like http://www.craigslist.org/sfo/bar/. Thanks. Salv Deliverables: 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased. Platform: windows 2000 server & XP Must be 100% finished and received by buyer on: Jan 25, 2003 2:31:16 PM 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. Additional Files: This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding. 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! M.Bilal (4 ratings) in Trois Riviers, Quebec Canada Bid id: 467,173   $20 (USD) Jan 11, 2003 5:38:00 PM EDT  7 (Good)     Hi Salv! I've checked your attached Access DataBase file and also your desired output i.e. http://www.craigslist.org/sfo/bar/ I can do it for you with a smart database design and a well shape SQL query in an hour without opening 30 recordsets at a single page.:) All you need is to accept my bid and you get it with you.Looking Forward Kind Regards, Bilal I'm not cheap but I'm cost effective and skilled           See 18 private reply(ies) to/from M.Bilal.