L
lucidxile
I have a field in my table called Job Number. This number is a ten
digit number in which the first four digits of that number represent a
certain client; the other six numbers represent other information about
the job.
What I'm trying to do is create a query that will pull information
based upon those first four digits of the job number. So we can compare
client information as requested.
What I'm looking for the query to do is:
1. Ask for the first four digits we want to work with.
2. We enter the first four digits.
3. It pulls all records associated with the job numbers that start with
those 4 digits.
I'm lost for a way to do this. Using "Like" doesn't allow me to input
the data and we have too many clients to create a different query for
them all. And using "[ ]" doesn't allow me to pull just the first four
digits.
Any help you can provide will be greatly appreciated. Thanks.
digit number in which the first four digits of that number represent a
certain client; the other six numbers represent other information about
the job.
What I'm trying to do is create a query that will pull information
based upon those first four digits of the job number. So we can compare
client information as requested.
What I'm looking for the query to do is:
1. Ask for the first four digits we want to work with.
2. We enter the first four digits.
3. It pulls all records associated with the job numbers that start with
those 4 digits.
I'm lost for a way to do this. Using "Like" doesn't allow me to input
the data and we have too many clients to create a different query for
them all. And using "[ ]" doesn't allow me to pull just the first four
digits.
Any help you can provide will be greatly appreciated. Thanks.