What's wrong with this Query?

[Richie27]

SELECT tblFNBox.box_number


FROM tblFNBox
WHERE (((tblFNBox.fileStartNo)>=Forms!frmFN_MainMenu!txt FindBox) And ((tblFNBox.fileFinishNo)<=Forms!frmFN_MainMenu!txt FindBox));

I basically have a txtBox called txtFindBox and when the user enters a number the query above finds a box based on that number.

In the fields for the box I have a fileStartNo and a fileFinishNo to indicate the files that are in that box so my query basically looks for values that are less than and equal to each of these numbers.

Returns nothing though....hmmmmm.......

Nevermind...........I fixed it..........too much sunshine is aggravating me! ;-)

[RuralGuy]

How about sharing your solution with other readers?

[Richie27]

I just had the < and the > in the wrong places. That's all. Simple really.

[RuralGuy]

Thanks. That makes the thread complete.