How many parameterscan I use in a Query?

S

Seb_tt1234

Joined
Jun 10, 2010
Messages
1
Reaction score
0
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?

Could you help me to fix my problem?

Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Parameter Syntax 6
Query Parameter Syntax 2
How to use txtboxes and Combo boxes in a form 3
Passing a query parameter using code to feed a subform 4
Query not working with report 1
Parameter query for a combo box using form field only works first 3
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Multiple Parameter Crosstab query filter by form 1

Top