[AccessD] SQL Float Type Conversion and Access

Happy Friday to all!  (Humor Day Reminder).  Anyway, I have an SQL
backend that has a few fields defined as float(ies).  When I do an
Access query against these floaties, and specify, for example the
criteria = 3, I get a message that my query is too complicated.  So, I
can either convert the SQL field to a better format that will preserve
the decimals, or I can figure out how to put criteria for a floatie in
Access.  I tried converting the field in SQL to numeric and it stripped
the decimal.  (backups are golden).  I don't want to go to nvarchar, I
am not sure I want to go to a double.  Any suggestions?  Thanks.