L
ljo1965
Guest
I have a table with alot of fields, there is three in particular that have me stumped.
they are 6amwatertemp, 9amwatertemp, 12pmwatertemp
I have set the query to ask for criteria for a few of the fields, what i want is for the query to ask for a between a temp and another temp and have the query apply the criteria to all three of these fields, without having to type it in three times. if the is any help you can give me i'd appreciate it
I also want to say that I have gotten countless help from reading other posts and want to say Thanks
ljo1965
they are 6amwatertemp, 9amwatertemp, 12pmwatertemp
I have set the query to ask for criteria for a few of the fields, what i want is for the query to ask for a between a temp and another temp and have the query apply the criteria to all three of these fields, without having to type it in three times. if the is any help you can give me i'd appreciate it
I also want to say that I have gotten countless help from reading other posts and want to say Thanks
ljo1965