ACCESS FEED: Re: [MS_AccessPros] Help Needed on Access Query

Senin, 07 Desember 2015

Re: [MS_AccessPros] Help Needed on Access Query

John

I had no idea you could use a "format" expression with LIKE. Thanks for sharing that one!

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <JohnV@msn.com> wrote :

James-

WHERE WBS LIKE "#.#" OR WBS LIKE "#.##"

If your first level can go up to two digits, then you'll have to add:

OR WBS LIKE "##.#" OR WBS LIKE "##.##"

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Dec 7, 2015, at 1:39 PM, James Asante asanteza@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have MS Access database text field "WBS" inherited form MS Project, WBS. Sample data include:

1
1.1
1.1.1
1.1.1.2
1.28
2
2.1
2.5

What query expression can I use to filter by levels. For example level 2 items: 1.1, 1.28, 2.1, 2.5?

Regards
James