> What would I need to write as a criteria so that when the QUERY is run, it prompts the user to select from a listbox
You must create a form to use the List Box control. If you really only need a query you can add the choices to the query parameter name. For example: SELECT "F1", "F2" FROM "Table1" WHERE "F1" = :enter_dog_cat_or_bird (see simple attached example). From the installed help see: Contents > Database Functionality > General Information > Working with Queries (Query Design / Parameter queries) and Working with Forms (Form Controls / List Box). On Sat, Aug 27, 2016 at 3:14 PM, alanon <alanon....@gmail.com> wrote: > Hi, > Thank you in advance for your help! > I'm trying to build a query that would list the records in a database where > the user selects from an existing list of categories. > > IE > there are 12 existing categories, each with a bunch of records. > the user wants to review just the records under the category "gas", but he > doesn't know that exact category name so he needs a listbox to show his > existing categories to select from. > > What would I need to write as a criteria so that when the query is run, it > prompts the user to select from a listbox so he can review the records for > that said category? > > Thank you. > Alanon > > > > -- > View this message in context: http://nabble.documentfoundation.org/ > libreoffice-base-building-query-need-help-with-input- > parameter-development-tp4191909.html > Sent from the Users mailing list archive at Nabble.com. > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- > unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
