Hi from * i think you mean all if yes then you dont need to assign * to itemid you just assign itemid='' by this way it select all records for referenece visit this link may this help you http://www.axaptapedia.com/Expressions_in_query_ranges
M Amir NazimSoftware Engineer MazikPakistan - Dynamics DivisionEmail : [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]: [EMAIL PROTECTED]: Thu, 13 Dec 2007 00:20:19 -0800Subject: [development-axapta] Select statement Hi,I have problem with a report query. In fetch method, I used 'while select' statement with several criterion. But when the user passes blank criteria, I want to use this like '*' in queries. But it doesn't work.Ex:If (!_ItemId) _ItemId='*';while select InventTablewhere ItemId==_ItemId...Any help appreciated.Syner__________________________________________________________Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping[Non-text portions of this message have been removed] _________________________________________________________________ Don't get caught with egg on your face. Play Chicktionary! http://club.live.com/chicktionary.aspx?icid=chick_wlhmtextlink1_dec [Non-text portions of this message have been removed]
