Search results

  1. L

    Update query not working?

    Of course! Yes - and the Stock List has a field called 'Availability' that I would like to update to 'no' if an item is checked out, and 'yes' if an item is checked in. Here's a little sample database I've been working on: ufile.io/8b5a3
  2. L

    Update query not working?

    Hello! Sorry, I'm relatively new to Access, but I've encountered a problem when creating a database for a charity's stock control. I have two tables - titled 'Stock List' and 'Stock Lend Register' - which are linked by the unique field 'Item ID.' As part of a checking out process, I've created...
  3. L

    Performing a query based on form entry

    Hi there! I'm relatively new to Access, but I'm currently developing a database for a charity I volunteer with that supports disabled adults and children. I have a table which contains the following fields: -Date of birth -Gender -Conditions 1/2/3 As we frequently have to report statistics...
  4. L

    Creating Table field based on field in another table

    Ahh, perfect! Thank you. The only reason I need the Condition Codes are for reports. Is there a way I could create a query to replace the Condition with the Condition Code on the reports?
  5. L

    Creating Table field based on field in another table

    Hello! Sorry, I am very new to Access, and trying to create a database for a charity I volunteer with. Essentially, I have one table called 'Main Table' with records including a condition selected from another table called 'Conditions List'. 'Conditions List' also has a field called 'Condition...
Top Bottom