asked 2012-03-20 14:26:16 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
I am in the process of converting a largish Access database to work with Libre office and quite a few of the queries I use involve the user entering a value (usually the year) when the query is run to produce reports. In Access one just paces the text for the prompt into the criterion field and data can be entered at the prompt to complete the query.
how does one do this in Base?
answered 2012-03-26 23:35:26 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
The next link have information about using parameters in a query: http://wiki.documentfoundation.org/Faq/Base/115
answered 2012-03-26 01:26:38 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
I solved a similar problem by creating a "BillingManager" table that has one record of billing report parameters. My query then uses the begin and end dates on the parameter record to select records to include on the billing. The only issue with this is that you have to remember to update the parameter table before running the query.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-03-20 14:26:16 +0200
Seen: 204 times
Last updated: Mar 26 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Hi @wheels5894, Did you find an answer to your question? I hope that you got everything convert from Access -> Base without too much trouble. Could you please give us an update and either mark a question as correct or post your own answer describing what you did to deal with this issue? Thanks!
qubit ( 2013-01-23 09:48:19 +0200 )edit