By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,929 Members | 1,830 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,929 IT Pros & Developers. It's quick & easy.

path name and wild card

rcollins
100+
P: 234
Here is the criteria I am using for my report...
Expand|Select|Wrap|Line Numbers
  1. (Permissions.Path)=[Forms]![frmCriteria]![Combo4])
  2.  
On the criteria form, if I pick R:\Acct\ from the list, I get just those values. I would like to get more, like R:\Acctg\EXCEL\ACCOUNTS PAYABLE, but am not sure how to use the wild card here. So far all of my attempts have been not good. Please help
Apr 23 '08 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,660
Usually the following should work :
Expand|Select|Wrap|Line Numbers
  1. (Permissions.Path) Like [Forms]![frmCriteria]![Combo4]) & '*'
Apr 24 '08 #2

rcollins
100+
P: 234
Worked great not sure what I was missing
Apr 24 '08 #3

NeoPa
Expert Mod 15k+
P: 31,660
Your code was basically saying "Find only those items which match the string exactly".
My version says "Find all items that start with the string".
Apr 24 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.