Re: [MS_AccessPros] Help Needed on Access Query

 

Hi John,

Thank you so much, It works perfectly!

Regards,
James Asante

On Mon, Dec 7, 2015 at 3:03 PM, John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.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

__._,_.___

---

Posted by: James Asante <asanteza@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___