Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tom22london

    Want to update a table via query on clicking command button

    Hi members, I have a hospital database having a table name ADMISSION, I have a form(ADMISSIONCHARGESDETAIL)through which i charge(fee) patient once they are ready to get discharged from the hospital. this form has primary feild ADMISSION_ID, which is linked with the ADMISSION table's...
  2. tom22london

    can i bypass my proxy server

    hi, my computer run's internet behind a proxy server, is it possible that i can bypass my proxy server, so that i can use programs to donwload music, videos etc. regards tom
  3. tom22london

    Exchange server goes down in 10 minutes

    As soon as Exchange server starts it operation, after 10 minutes the IMS and Information Store services goes down completely. Please help me out
  4. tom22london

    Following are the tables (Feilds wi

    Following are the tables (Feilds with star are foreign keys, with + sysmbols are primary keys) Borrower(bor_id+, bor_name, bor_maxbooks) Book_title(bt_id+, bt_name,pub_id*, value) Book_copy(bc_id+, bt_id*, date acquired) Loan(bor_id+*, bc_id+*, date_out, date_due, date_back)...
  5. tom22london

    is there any other shorter way to write these queries

    following are the three queries but its too long however answer is alright, but is there any way to make these query shorter Following are the tables (Feilds with star are primary keys) Borrower(bor_id*, bor_name, bor_maxbooks) Book_title(bt_id*, bt_name,pub_id, value) Book_copy(bc_id*...
  6. tom22london

    how shall i find the total value of all books

    how shall i find the total value of all books the borrowers have currently on loan, where the total value is at least £20 for each borrower. Following are tables, Borrower (bor_id, bor_name, bor_maxbooks) Book_title (bt_id, bt_name,pub_id, value) Book_copy (bc_id, bt_id*, date acquired)...
  7. tom22london

    very confusing query !

    how can i find title of book whcih have the same publisher 'tom', but i am not supposed to include 'tom' in my output. following are the tables, Borrower (bor_id, bor_name, bor_maxbooks) Book_title (bt_id, bt_name,pub_id, value) Book_copy (bc_id, bt_id*, date acquired) Loan (bor_id, bc_id...

Part and Inventory Search

Back
Top