Adding A Filter To A Simple Query

C

carl

I anm trying to add a greater than/less than formula to my query. The field I
am trying to filter is named "Time"

The data looks as so:

93000
93020
93040
93050

I would like to add a formula to my query that will allow me to filter down
to the data bewtween 2 times (for example between 93015 and 93045). If
possible, I would like to be prompted to enter the 2 times when the query is
run.

Thank you in advance.
 
O

Ofer

Try this

Select * From TableName Where [Time] Between [Enter start time:] And [Anter
End Time:]
 
Top