I'm not sure if this is a syntax problem or not, but:
I am trying to design a parameter query using a form for entery. The trick is that I am trying to use a wildcard in order to select the data for one of two job sets.
My job number format looks like this:
06-07-123
or
07-01-006
I can get the query to work without the wildcard by using anexact number, but I am trying to pull all the jobs that begin with "06" or "07" (but not in the same query).
In my query, I direct the query to get the records based on the data from this field:
Forms!frmDRSNoInput!txtDRS1.value
I have tried using the wildcard as follows:
Like "[Forms]![frmDRSNOInupt]![txtDRS1].[Value]*"
Additionally, I experimented with different possibilities, but as you can see, I wound up here.
All help is appreciated.
Jake
I am trying to design a parameter query using a form for entery. The trick is that I am trying to use a wildcard in order to select the data for one of two job sets.
My job number format looks like this:
06-07-123
or
07-01-006
I can get the query to work without the wildcard by using anexact number, but I am trying to pull all the jobs that begin with "06" or "07" (but not in the same query).
In my query, I direct the query to get the records based on the data from this field:
Forms!frmDRSNoInput!txtDRS1.value
I have tried using the wildcard as follows:
Like "[Forms]![frmDRSNOInupt]![txtDRS1].[Value]*"
Additionally, I experimented with different possibilities, but as you can see, I wound up here.
All help is appreciated.
Jake
