Sum

[kadara]

Hi,

I have a table with the following fields:
BatchID, Batch, Quantity, Date

I would like to display in a textbox the sum of quantities between two dates for a single batch. How could I do that?
Please help.

Thanks.

 

[Poppa Smurf]

Create a query to total the quantity. Will the date range be entered by the user?

Beware Date is a reserved word so I suggest that you change it to batch_date or some other meaningful name

 

[kadara]

OK. I created the query.
But how could I import the query field (total of quantity) into the textbox.
About the data range: I put two datapickers on the form (start_date and end_date). With these datapickers I enter the range.