Search results

  1. R

    lookup from one table to two fields

    Hi all. I have table; tblBuildings one field of which is Supervisor which looks up a field in tblSupervisor which contains contact details etc.. Then a query gives me a report listing the contact details for each building.Note, one supervisor can be responsible for more than one building...
  2. R

    Appending multiple records to grand child table

    Hi. I have a database based on Microsoft Assets Database template. I have three tables: tblBuildings; Parent. PK BuildingID tblAssets; Child. PK AssetID, linked to parent via BuildingID tblMaintenance.Child of tblAssets. linked via AssetID Service reports...
  3. R

    Type mismatch

    Hi. I'm trying to add several records, 7 days apart between two dates. This is my first attempt at coding and after lots of reading and poring over various fora I've come up with the following code which I'm using in a simple test prior to adding to my existing DB. My problem is that the...
Back
Top Bottom