How many parameters can I use in a Query

[seb]

Hello
I have a relational database in Access 2003. Now Im trying to write a parameter query using four tables(tblReference, tblCounty, tblWords, tblWeb). The first two parameters belongs to tblArts.
The first parameter is: Between [Forms]![FSearch].[txtStart] And [Forms].[FSearch].[txtEnd]
The second parameter is: Like [Forms].[FSearch].[txtName] & "*"
The Third Parameter is:Like [Forms].[FSearch].[txtCity] & "*"
The fourth Parameter is Like [Forms].[FSearch].[txtWord] & "*"
I also have in the query three more fields (with no parameters) two from tblArts and one from tblWeb

When I run the query there is no records, however, If I delete the first parameter the Query works.How many parameters can I use in a Query with four related (1 to many) tables?



Could you help me to fix my problem?

Many thanks

[NTC]

there is no practical limit to parameters.

and there is no mis-function of the software.

one will learn the hard way that queries are never ever wrong - - one may not understand the results they present - - but they are never wrong....

multiple AND OR parameters can get mind bendingly confusing....so do it step by step....

[seb]

NTC
It s good to hear that there is no practical limit to parameters. I'll do each parameter step by step.

Than you very much

[seb]

After careful writing the parameters, now my Query is Working.