Running two Parameter Queries on a Report?

[Mitt1]

Can I run two parameter queries on report and if so how?

Basically I've created a report showing customer payments for a specific month.

First query is to enter the month (I have this one done)
Secondly I want to show a specific customer's payments for the enetered month (don't have this done)

Currently, when I search for a month (first query) I get the payments for every customer. I want to use the second query to show the payments for a specific customer. I am confused how to do this (does it involve SQL or VBA). Thanks.

 

[Grumm]

I guess you already have a form where you can enter the month and use that text-field in your query ?
If so, you only need to add a new text-field. (Or maybe a drop-down to select the customer).
And in the query add in the where statement "or ((tblPayement.Cust = txtCust.value) and (txtCust.value <> ""))"

You need to check if the txtCust is not empty. Otherwise you get the wrong data.