Ask Your Question
0

Multi-Query with wildcard in Base [closed]

asked 2013-04-28 21:44:45 +0200

esanroma gravatar image

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!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-21 14:58:36.285821

1 Answer

Sort by » oldest newest most voted
1

answered 2014-04-27 18:04:34 +0200

Alex Thurgood gravatar image

updated 2014-04-27 18:07:31 +0200

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-04-28 21:44:45 +0200

Seen: 806 times

Last updated: Apr 27 '14