I
Ittie06
I have a database that stores information about parts that have been ticketed
as defective. I need to make a query that will allow me to generate a report
using the following criteria:
1- a beginning and ending date range
2- a partial part number
I have the date range down, but I cannot get my query to search by partial
field in part numbers. For example, I have part numbers 123A4567RK and
123A4567SF. I want to be able to type in the center part of the number
(4567) and come up with all of the RK and SF numbers that are defective.
Any help would be great.
as defective. I need to make a query that will allow me to generate a report
using the following criteria:
1- a beginning and ending date range
2- a partial part number
I have the date range down, but I cannot get my query to search by partial
field in part numbers. For example, I have part numbers 123A4567RK and
123A4567SF. I want to be able to type in the center part of the number
(4567) and come up with all of the RK and SF numbers that are defective.
Any help would be great.