Partial Parameters

[BJM]

I hope I can communicate my need here without sounding as
inexperienced as I'm afraid I am!

Is there any way to format a parameter so that it will
return records from a partial match?

For example, I have a group of teachers who are asking to
be able to print out class lists. They only know the
course codes by their first 5 characters. The course code
field is, of course, populated by the entire 8-character
string.

Can I create a course code field parameter that would
return all records whose value *begins* with what the user
enters?

Is there something akin, perhaps, to the LIKE wildcard? Or
VB code that would trim the field value to check for a
match?

Thanks,
BJM

 

[Bas Cost Budde]

Put that Like into the query; then, when you pass as its value some
wildcarded expression (zxcvb*), it will do what you want. So I hope!

Alternative in this case may be to put the parameter in the criteria
line at a column where you have Left(yourField,5) above.

I hope I can communicate my need here without sounding as
inexperienced as I'm afraid I am!

You're better of sounding inexperienced than sounding seasoned when you
aren't!

 

[Guest]

Hi,
Thanks for your reply.

I have tried every which way to put the LIKE in the
criteria row for the class field. It doesn't seem to work.

Will try the Left idea as a separate field and pass the
results to the correct form control.

BJM

 

[Ken Snell]

Like [Enter the class code:] & "*"

 

[Guest]

Ah ha! The asterisk has to be a string value! That's what
I was missing.

Many, many thanks!!!!

BJM

-----Original Message-----
Like [Enter the class code:] & "*"


--
Ken Snell
<MS ACCESS MVP>

Hi,
Thanks for your reply.

I have tried every which way to put the LIKE in the
criteria row for the class field. It doesn't seem to work.

Will try the Left idea as a separate field and pass the
results to the correct form control.

BJM

its
value some want.
So I hope! sounding
as

.