I have two fields, a 'Start Time' and an 'End Time'. I am trying to create query that you can enter the start time and the end time and only those records will show.

I have used the between function, but I can only use either the 'Start Time' field or the 'End Time' field. I need to be able to use both fields.

The problem you are probably having is that you have two seperate date fields. Between will only work with a single field. You need to use greater than and less than and pass the parameters in a WHERE clause, like (remember to check for Nulls in your code - I am not here):

Dim dtStart As Date
Dim dtEnd As Date
Dim sLink As String

dtStart = Me.cboStart
dtEnd = Me.cboEnd

sLink = "[StartDate] > #" & dtStart & "# AND [EndDate] < #" & dtEnd & "#"

Then put this in the WHERE clause of the DoCmd.OpenReport line.

I am not sure if I got the greater than and less than in the right place. I always get them mixed up (ambidextrous).

Did that help?


mmcdonal

Sorry for the ignorance, but I am not sure where to insert these lines. In my query I am just using the basic commands.

I am assuming that you are using a form to launch a report, and that the user can select a range of start and end dates from two combo boxes that look to the actual data and show only actual dates in the data (use the combo box wizard). Then you have a button to launch the report. This code goes on the on click event of that button. If you use the wizard to launch the report, you will get this code:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "rptYourReportName"

DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

You paste in the code to replace stLinkCriteria, and change stLinkCriteria in the DoCmd line to sLink. Make sure to refer to the combo boxes by their proper names, etc. I used sample names.

Did that help?



mmcdonal