Search a Date Range - Access 2010

[webdoc]

I'm using a form to run a query. I have a start date and an end date on the form and I want to only return records in the query that fall between those dates. If the dates are left blank, I want the query to return every record. The fields use the Short Date format. I would prefer to do this as part of the query design, using the Criteria field for those columns, but I'll take whatever I can get at this point. Any help is appreciated!

-Doc

 

[Redwolfx]

In the Where Clause

Where Date Between Forms![Form Name]![Starte Date box] And Forms![Form Name]![End Date box].

This will get you the info between the two dates. I'd probably write a separate query to do all records, Then use VBA like

The VBA Code is untested

Private Sub ButtonName_Click()
On Error GoTo Err_ButtonName_Click

    Dim stDocName As String
 
IF Forms![FORM Name]![Start Date Box] = "" AND Forms![FORM Name]![End Date Box] = "" Then
    stDocName = "Query1Name"
Else
    stDocName = "Query2Name"
End If
    
DoCmd.OpenQuery stDocName, acNormal, acEdit

Exit_ButtonName_Click:
    Exit Sub
Err_ButtonName_Click:
    MsgBox Err.Description
    Resume Exit_ButtonName_Click
    
End Sub

 

[webdoc]

Thanks! I'll give those a shot and see what I can do.

-doc