Invoicing by month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
JB said:
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
Click to expand...

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.
 
Back
Top