Need to change MS Access 2000 Query

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Need to change MS Access 2000 Query

Logged in as: Guest

arrSession:exec spGetSession 2,3,3357

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Need to change MS Access 2000 Query
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Need to change MS Access 2000 Query - 6/13/2005 4:27:54 PM

gilgalbiblewheel

Posts: 14
Score: 0
Joined: 4/6/2005
From:
Status: offline

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.