Retrieve a specific value based on the start of date range

See more:

VB

MySQL

CrystalReports

Good day to all of you.

I would like to ask if someone knows an idea to solve my problem, i am dealing with this for almost a week and i still don't get what i want to achieve.

Here it is, First I have table "Product_Inventory" where it has the ff fields:

secret_code
inv_date
inv_pro_category
inv_pro_sub_category
inv_pro_code
inv_pro_name
inv_beg
inv_pur_ref
inv_pur_ret
inv_dam
inv_sal_rel
inv_sal_ret
inv_ending
inv_actual

Example date screen shots here: https://dl.dropbox.com/u/65392916/Product_Inventory.png

This is the result output from crystal report: https://dl.dropbox.com/u/65392916/Report.png


Where beginning inventory should not be 53 when i set the date range from Nov 15, 2012 to Nov, 17, 2012

What happens is that crystal report summarized all beg inventory from nov 15 to nov 17. Inv_beg should start from the beginning of date range "Nov 15, 2012" = 25 pcs

Hope someone can understand me and help. thanks a lot in advance hope to hear from you soon