Year Range Query?

[drace1111]

I have a table that lists hitch applications for motor vehicles. The vehicles are listed by "make", "model", "year from", and "year to". I want to create a query that can pull all models of a chosen make that fall between and include "year from" and "year to". IOW, by choosing a specific year, only car models made during that year would be available. Can this be done using the fields that I have, or do I need to modify the table?

Thanks for any help.

 

[LittleSmudge]

So like

SELECT make, model FROM tblVehicle
WHERE YearFrom <= [intYearValue] AND YearTo >= [intYearValue]



'ope-that-elps'


G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[drace1111]

Thanks! That was perfect.