Playing with Queries

Missing a numeric value. Unable to proceed.

SELECT * FROM invoices WHERE corp_id = 53 AND invoice_number = #FORM.invoice_number# ORDER BY invoice_number SELECT parts.part_id, parts.part_number, parts.part_description, part_categories.part_category_name FROM parts, part_categories WHERE part_categories.part_category_id = parts.part_category_id AND parts.corp_id = 53 AND (parts.part_number LIKE '%#Trim(FORM.item_filter)#%' OR parts.part_reference LIKE '%#Trim(FORM.item_filter)#%' OR parts.part_description LIKE '%#Trim(FORM.item_filter)#%' OR part_categories.part_category_name LIKE '%#Trim(FORM.item_filter)#%') ORDER BY part_categories.part_category_name, parts.part_number, parts.part_id Playing with Queries