Search results

  1. T

    Update Query - multiple rows

    Hello all, Having a blonde moment! I have a properties table where there is a row for each property with a reference number. [property ref], [property name] etc In a second table are the charges for each type of maintenance for each property. [Property ref], [Charge category], [Charge amount]...
  2. T

    Creating a schedule

    Hi everyone, I am creating a database for a maintenance business. There are numerous properties in a table, another with charges for each maintenance type eg cleaning, pool maintenance, gardening etc. I need to create a schedule to show available dates for each maintenance type into which one...
  3. T

    Update a field based on selection in other field

    Good evening, Its been a while since i did an access database so am a bit rusty! Can someone please advise? I have two tables, Bookings and Properties, both are related using a Property Ref field. On my data entry form bookings there is a field for security deposit amount. I want this to be...
Back
Top Bottom