Is it possible to create a "parameter" query in Kexi which will ask the user to input a value to be used in the query. (I want to create this query using the query design tool.)
As an example in MS Access I would use the following SQL to achieve this: SELECT DISTINCTROW tblItemMaster.ITEM, tblItemMaster.ITEM_DESC, tblItemMaster.TOT_ROLCST, tblItemMaster.PRICE FROM tblItemMaster WHERE (((tblItemMaster.ITEM)=[enter part])); In Access my parameter is "[enter part]". Thanks for any help with this. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
