Search results

  1. A

    Is this on the right lines

    Hi, I am just trying to normalize these data here: An initial call is logged by a first line support analyst who assesses the severity of the problem and places the call in a pool. The call is picked up by a problem analyst who in turn allocates it to a specialist analyst based on their...
  2. A

    Query to add data from form into table

    Hi, I am trying to create a simple library system that allows loaning returning and reserving CD's So far i have done issueing and returning loans. However i am a little stuck on how i would reserve a CD. So far i think it would be best if lets say the user opens a form and their will be two...
  3. A

    Query to insert data from form into table

    Hi, I am trying to create a simple library which allows issueing, returning and reserving loans. So far i have been able to do issueing and returning. However how would i go about making a query so that when a user opens the reservations form there will be two list boxes, one full of...
  4. A

    Query adding content to two fields?

    Hi, I am trying to create a simple library system that can issue and return loans. At the moment i have created a working system to issue loans. I have created a query that inserts the correct information into the borrowers table but for some reason it inserts the borrower ID into the first...
  5. A

    Return Item Query

    Hello, I am creating a basic library database that loans out CDs to borrowers. At the moment i am trying to create a return query so CDs can be returned. I need to Append the values (AccessionNo, BorrowerID, DateIssued, Date Due) into the LoanHistory table whilst also adding data to the...
Back
Top Bottom