A
Allison
Access 2003, Win XP, all service packs installed.
I used Allen Browne's SQL code to populate a list of report names for a
combo box on my main form (http://allenbrowne.com/ser-19.html). This works
fabulously!
Two things.
1. Can I somehow filter out the "rpt" at the front of these report names?
2. Can I somehow choose to display only those reports that contain a
certain word, such as "distribution"?
I was fiddling around with modifying the "WHERE" statement, but my knowledge
of SQL is almost null. I can read it, but I can't create it.
Any pointers? Or is this not possible?
Thanks for your help.
Allison
I used Allen Browne's SQL code to populate a list of report names for a
combo box on my main form (http://allenbrowne.com/ser-19.html). This works
fabulously!
Two things.
1. Can I somehow filter out the "rpt" at the front of these report names?
2. Can I somehow choose to display only those reports that contain a
certain word, such as "distribution"?
I was fiddling around with modifying the "WHERE" statement, but my knowledge
of SQL is almost null. I can read it, but I can't create it.
Any pointers? Or is this not possible?
Thanks for your help.
Allison