Search results

Hi, I have a database that stores gas safety audits by engineers. I would like to create a query that counts the total number of 'Post Job Audits' per engineer. I have tried using the DCount in the query to do this which shows the correct total but displays it against all engineers and not for...

Hi, I have a field called 'Audit Date' and 'Period'. I would like the 'Period' field to automatically the period number if the audit date entered in the 'Audit Date' field is between a certain date range. Below is the date ranges and period numbers 30-04-2017 - 27-05-2017 = Period 1...

Hi All, Not sure if this has already been covered, if so you can point me in the right direction. I have created a stock tracking data base but would like to incorporate a shipping proforma form that can be printed, emailed and recorded. I would like to create a button on the asset list form...

Hi All, New to programming but I have recently used Access to create a stock tracker and found your forum very helpful. Been tasked to expand on the database so thought it would be useful to join. Ck_One