Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    Regular Coder
    Join Date
    Mar 2005
    Thanked 1 Time in 1 Post

    Need to change MS Access 2000 Query


    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?

    I'll post a sample for you to check. I reduced the data to make it postable, but it affected the "chapter" Query and the "verse" Query.

    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.
    Attached Files Attached Files


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts