Search results

I have two tables that are relevant to the query I would like to perform. The important information in each is as follows: Equipment_TBL: with several fields but the only one of importance is the primary key - Equipment_ID Maintenance_Record_TBL: with fields Maintenance_Record_ID (Primary...

I have a table (Equipment_tbl) where I have several fields, with the primary key being (Equipment ID). I have designed a query to find the last equipment ID added (newly added equipment ID). I then want to append this newly added equipment ID to a compatibility matrix table which compares each...

I have quite a complex database so I will just explain the relevant tables/forms. I have an equipment table which collects information in the following fields: Equipment ID (primary key), Equipment Description (text field), Equipment Sub Sub Category (lookup from another table). A piece of...

I am using Access 2003 and am relatively new to access. I have 4 main tables in my database, tables 1, 2A, 2B1 & 2B2. The user can enter information via tables "1", "2A" or "1", "2B1", "2B2" depending on how they respond to a question in table 1. I have set up 15 forms as the tables...

I have 20 subforms all with their own primary key eg (01-000001, 02-0000001, 03-000001) and so on, where the 01 relates to the subform number and within that subform the 000001 part increments by one each time. The main form is MTF-000001, again with the 000001 part incrementing by one. Is...

Hi. I'm relatively new to access and thought I might try here for some help. I have created a form with 21 questions, all of which have a drop down menu where the user picks either "Yes" "No" or "N/A". I have one final question at the end of the form and I think I need a sort of IF...