Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 13th, 2005, 11:10 PM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default Need to change MS Access 2000 Query

http://i.domaindlx.com/wheelofgod/Tripledemo.asp

I need to change the Query somehow. I had earlier made a table consisting of book # , Chapter # , and verse #. I had seen a triple listbox online and asked the designer to make the necessary changes to make it work. So he created 3 Queries, a book Query, a chapter Query, and a verse Query.

But later I decided to remove realizing that some columns were unnecessary, it messed up the chapter Query and verse Query. Can someone guide me how to recreate the Queries?

What I need to to is delete the "chap" column and the "vers" replacing them with the existing "chapter" column and the "verse" column. I would appreciate if someone can work with me on this one.

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm





Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the format of MS Excel Cells from MS Access hewstone999 Access VBA 0 March 7th, 2008 07:19 AM
Emailing From MS Access 2000 baNTON Access 5 October 13th, 2007 09:58 AM
Database migration MS Access 2003 to MS SQL 2000 ayazhoda SQL Server 2000 3 April 23rd, 2007 11:38 AM
MS Access 2000 kvidy Access 12 June 10th, 2005 10:36 AM
MS Access 2000 Replication ppenn Access 0 February 3rd, 2005 04:27 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.