Simple search form

[jimmylad]

I have one table containing ID,d,m,y,temp,salinity fields. i would
like to create a form to search for a set of temperatures between 1
value and another value of temperature which will then return the
dates these temps fell. any help for a real newbie would be
appreciated

 

[Rick Brandt]

I have one table containing ID,d,m,y,temp,salinity fields. i would
like to create a form to search for a set of temperatures between 1
value and another value of temperature which will then return the
dates these temps fell. any help for a real newbie would be
appreciated

Not sure why you chose to store the date in three separate fields but...

SELECT d, m, y, temp
FROM YourTableName
WHERE temp BETWEEN SomeValue AND SomeOtherValue