Parameter Query for "ends with **"

  • Thread starter Thread starter Student Databaser
  • Start date Start date
S

Student Databaser

How do i create a query that grabs only records where the Offering_ID field
ends with 05 or 06, or 07, or better yet, how to i make it so that it prompts
users to enter this info. The records in the 'Offering_ID' Field are not all
the same length though.

Is this possible?
 
For groups use ---
Between Like "*" & [Enter low last digits] AND Like "*" & [Enter high last
digits]
 
How do i create a query that grabs only records where the Offering_ID field
ends with 05 or 06, or 07, or better yet, how to i make it so that it prompts
users to enter this info. The records in the 'Offering_ID' Field are not all
the same length though.

Is this possible?
Click to expand...

Like "*" & [Enter value]
 
It says "The Microsoft Jet database engine does not recognize '[Enter last
two digits] as a valid field name or expression.

?? What now?


KARL DEWEY said:
For groups use ---
Between Like "*" & [Enter low last digits] AND Like "*" & [Enter high last
digits]
--
KARL DEWEY
Build a little - Test a little


Student Databaser said:
How do i create a query that grabs only records where the Offering_ID field
ends with 05 or 06, or 07, or better yet, how to i make it so that it prompts
users to enter this info. The records in the 'Offering_ID' Field are not all
the same length though.

Is this possible?
Click to expand...
Click to expand...
 
How do i create a query that grabs only records where the Offering_ID field
ends with 05 or 06, or 07, or better yet, how to i make it so that it prompts
users to enter this info. The records in the 'Offering_ID' Field are not all
the same length though.

Is this possible?
Click to expand...

LIKE "*" & [Enter last two digits of Offering_ID:]
 
Where are you putting it?
Post your query SQL. Open the query in design view, click on menu VIEW -
SQL View, highlight all, copy and paste in a post.
--
KARL DEWEY
Build a little - Test a little


Student Databaser said:
It says "The Microsoft Jet database engine does not recognize '[Enter last
two digits] as a valid field name or expression.

?? What now?


KARL DEWEY said:
For groups use ---
Between Like "*" & [Enter low last digits] AND Like "*" & [Enter high last
digits]
--
KARL DEWEY
Build a little - Test a little


Student Databaser said:
How do i create a query that grabs only records where the Offering_ID field
ends with 05 or 06, or 07, or better yet, how to i make it so that it prompts
users to enter this info. The records in the 'Offering_ID' Field are not all
the same length though.

Is this possible?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top