I'm building a database that contains error codes and the starting part number and the ending part numbers effected. The part numbers are continues, they go from 0 to 120. The number of parts is too large to include all of them in one table. So, I have a made a form that has a text box where the user enters a part number and a subform table will show any records that have that part number between the starting and ending part number. I tried to do it in VBA but I couldn't get the code to work. So I'm trying to do it with a query.
I have a query which will use the text box in the form as a criteria but I can't figure out how to make the criteria less than and greater than.
I've tried the statement below but do not get any results.
WHERE ((([Forms]![Table1_frm]![Search])>=[StartingPartNum]));
Thank you in advance.
I have a query which will use the text box in the form as a criteria but I can't figure out how to make the criteria less than and greater than.
I've tried the statement below but do not get any results.
WHERE ((([Forms]![Table1_frm]![Search])>=[StartingPartNum]));
Thank you in advance.