Data Collection

[Alimbilo]

Which code can I use to get data from a certain range of Date?

Example:

Date: 6/3/2008

Items Qty Sold Left
-----------------------------------
Books 50 5 45
Pencils 90 30 60


I am trying to get the total of Books and Pencils between 6/3/2008 and
6/23/2008

Thanks

 

[Golfinray]

In the criteria field you can type Between 6/3/2008 and 6/23/2008.

 

[Alimbilo]

Which criteria field?

In the criteria field you can type Between 6/3/2008 and 6/23/2008.

 

[John W. Vinson]

Which code can I use to get data from a certain range of Date?

Example:

Date: 6/3/2008

Items Qty Sold Left
-----------------------------------
Books 50 5 45
Pencils 90 30 60


I am trying to get the total of Books and Pencils between 6/3/2008 and
6/23/2008

Thanks

What are the fields in your Table? What you posted looks like a report rather
than a table. Please post the name of your Table and the names and datatypes
of the fields in that table.