Simple search form

  • Thread starter Thread starter jimmylad
  • Start date Start date
J

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
 
jimmylad said:
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
Click to expand...

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
 
Back
Top