Report for Clients

[soldat452002]

Hello,

I have a report database that provides my company with clients that took our training modules and notify us of which clients completed our trainings.
The clients can complete training in 3 States and "Passed" means they are good to go.


I download an excel report daily and import it to Access on a daily basis. Problem is the Report is over 8,000 rows long
and basically I just need the clients that completed training within past 48 hours. The excel report provides a date of completion.

can someone please assist me with the code that only pulls those clients that "Passed" within the last 48 Hours. Here is my SQL Statement I use on the RecordSource.

SELECT report.SPS, report.FirstName, report.region, report.id, report.AZ_Cert, report.AZStatus, report.CA_CERT, report.CAStatus, report.OR_CERT, report.ORStatus, report.Completed FROM report WHERE (((report.Completed)=False));


The completed checkbox removes the record from the cert queue. How can I do this more efficiently? I think I have it right.

Private Sub Completed_Click()
Const cstrPrompt As String = _
"Are you sure you want to complete this record? Yes/No"
If MsgBox(cstrPrompt, vbQuestion + vbYesNo) = vbYes Then
If Me.Dirty Then
Me.Dirty = False ' save the record
Forms!frmRecertView.subfrmRecert.Requery
End If
End If
End Sub


I uploaded a screen shot of my database.