Ask Your Question
1

Qureis in Base - How can I get a promt for a sort value? [closed]

asked 2012-03-20 14:26:16 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-03-13 04:54:50.518492

Comments

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 gravatar imagequbit ( 2013-01-23 09:48:19 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2012-03-26 01:26:38 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 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.

edit flag offensive delete link more
0

answered 2012-03-26 23:35:26 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

The next link have information about using parameters in a query: http://wiki.documentfoundation.org/Faq/Base/115

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-03-20 14:26:16 +0100

Seen: 1,063 times

Last updated: Mar 26 '12