Invoicing by month

[JB]

I have a form which contains a subquery (like a subform). I want to be able to control the query's data by

a) giving the ORDERDATE a limited criteria (only one month like 1-10-03 to 31-10-03)

For this, I have made 2 unbound text boxes in the form with the names BeginningDate and EndingDate

b) It should display the results of one customer only - How do you bind the customer ID with the CustomerID text box in the main form

Please help.

 

[Marshall Barton]

I have a form which contains a subquery (like a subform). I want to be able to control the query's data by

a) giving the ORDERDATE a limited criteria (only one month like 1-10-03 to 31-10-03)

For this, I have made 2 unbound text boxes in the form with the names BeginningDate and EndingDate

b) It should display the results of one customer only - How do you bind the customer ID with the CustomerID text box in the main form

Add criteria to the query. Under the OrderDate field use
something like:

Between Forms!themainform.BeginningDate And
Forms!themainform.EndingDate

Under the CustomerId field:

=Forms!themainform.txtCustomerId

where CustomerId is the name of the text box boound to the
CustomerId field.