Access Search Form Help Needed

**Thomas Mullins** · 09-28-2017, 06:22 AM

Hello, my name is Thomas.
I am in need of assistance with the Criteria needed to make my Search form work properly.
Currently my formula of Like "*" & [Forms]![]![]& "*" works for most fields, but for fields with decimal places and negatives, etc. I am having issues.

SELECT [Master Table].Category, [Master Table].[FFR Item #], [Master Table].Supplier, [Master Table].[Supplier Item #], [Master Table].Description, [Master Table].Shape, [Master Table].[Length Blade Only Inches], [Master Table].[Length Handle Only Inches], [Master Table].[Length Inches], [Master Table].[Width Inches], [Master Table].[Height Inches], [Master Table].[Diameter Inches], [Master Table].Material, [Master Table].[Material Handle Only], [Master Table].Color, [Master Table].Certification, [Master Table].[FDA Approved], [Master Table].[Dishwasher Safe], [Master Table].[Stock Item], [Master Table].[Use in Hot Case], [Master Table].[Forged/Stamped], [Master Table].[Instruction/Use and Care Sheet], [Master Table].[Temperature Range Low ◦F], [Master Table].[Temperature Range High ◦F], [Master Table].Gauge, [Master Table].[Capacity in Quarts], [Master Table].[Capacity in Ounces], [Master Table].[Domestic/Import], [Master Table].[Country of Origin], [Master Table].MOQ, [Master Table].[Reorder Point/Max], [Master Table].[2017 FFR Catalog Page #], [Master Table].[Dummy Item #], [Master Table].Notes
FROM [Master Table]
WHERE ((([Master Table].[FFR Item #]) Like "*" & [Forms]![Search]![FFR Item #] & "*") AND (([Master Table].Supplier) Like "*" & [Forms]![Search]![Supplier] & "*") AND (([Master Table].[Supplier Item #]) Like "*" & [Forms]![Search]![Supplier Item #] & "*") AND (([Master Table].Description) Like "*" & [Forms]![Search]![Description] & "*") AND (([Master Table].Shape) Like "*" & [Forms]![Search]![Shape] & "*"));

I've tried to attach my file, but I believe it is too large.

**aytee111** · 09-28-2017, 07:03 AM

For number fields, using LIKE doesn't make sense - if the user enters 5.5, what would you expect when you say LIKE 5.5? So for numeric fields you need either equal to or a range (BETWEEN).

To attach a file, first compact and repair, then zip it. Also, make a copy of it and remove objects that aren't applicable.