Recent content by CK_One

Hi Minty, Thanks for the quick reply. I have tried your suggestion and I get the same result. List of all engineers with the total post job audits against each engineer. The records that should be shown is Ali Amaan with 2 and James Lee with 1. SQL code below SELECT [Engineers...

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...

Thanks Steve, The calculated (looked up) period would be a better option but I cant work out how the periods are calculated by the financial team. I have requested this info and waiting for them to get back to me. The query is now work perfectly. Thanks for your help Regards,

Hi Sneuberg, I thought I had it working but it seems I was wrong and I am now pulling out what little hair I had. I have attached a copy of my database for better understanding. When I run the 'qryPeriodPlog' nothing seems to happen even though the coding is exactly the same I cant see where...

Thanks Sneuberg and Plog, the solution works perfectly. Much appreciated :)

Sneuberg, Could you upload the updated database with the new query so I can see how it is done? Thanks

Thanks Sneuberg and Plog The periods are set by our financial team and I am not sure what rules they apply to set the periods each year. The query works fine but I am new to Access and would like the period to be automatically calculated when a user enters the audit date in the job audit...

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 Minty, Thanks for your reply and apologies for the late response. Been on holiday haven't had the chance to try your suggestion. I have created the append query below but was not sure how to add the where condition for the unique ID. INSERT INTO Assets ( [Ship OEM Brand], [Ship OEM Model]...

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