Search results

I have an access query to record equipment casualty reports. There are initial dates and correct dates. I need to compute the number of days from initial date to today if the report is active, or compute the number of days from initial date to correct date if the report is closed. Below is my...

I have a find duplicate query that found duplicate records in my Parts table. I wrote VBA code to run the query qryDuplicateParts when I opened my form PartsListing. Is there a way in VBA to delete the duplicate records? Could I have created VBA code to find and delete the duplicate records?

My loop code is stuck. It only returns the first record. What am I missing? :banghead: Dim rs As DAO.Recordset Dim asReturn As String Set rs = CurrentDb.OpenRecordset("SELECT * FROM Parts A") 'rs.MoveFirst If Not (rs.EOF) = True Then rs.MoveFirst Do Until rs.EOF asReturn =...

I need a DLookup but for only part of a field in an access table.