Multi-Query with wildcard in Base

Hi,

I would like to make a Form that shows the results of a question about diferent parameters. Example:

TABLE-BOY (Name, Age, Sex)
QUERY (Name :AskName
Age :AskAge
Sex :AskSex

Now, when the query runs asks the user for a AskName, AskAge & AskSex

BUT the user must write something for each parameter.
I wloud like, for example, answer only for AskAge = 8, and ‘noting/*/return/?’ to the other params. And I would like the query shows all the boys with 8 years, no matter his name or sex.

Like: SELECT * FROM BOY.Name * FROM BOY.Sex 8 FROM BOY.Age

If this kind of query could be possible, I’ll use it in a Form and whith multiple tables to simplify the use for the users of the DB.

Thanks a lot!

You can build queries with parameters :
https://forum.openoffice.org/en/forum/viewtopic.php?f=61&t=69304&p=309197&hilit=base+query+parameter#p309197

https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=68260&p=304211&hilit=base+query+parameter#p304211

Using SQL in forms to filter :
https://forum.openoffice.org/en/forum/viewtopic.php?f=39&t=66476&p=295579&hilit=base+query+parameter#p295579