I have a table containing names and addresses (one field name is “street name”), and am setting up a query to select all people in a particular street. Is it possible to set up this system so that I would be able to include an “editable” field in the query and be able to enter the required street name? This would avoid the necessity to set up a separate query for every street in the main table. I have some experience of databases, but am new to Libre Office and “feeling my way” to some extent.
Hello,
You can do this by using a parameter. Please see this post > Way to pass parameters into queries
.
The link discusses using SQL. Here is one using the Design mode:
.
