Thank you so much. I think you are right. this will be better. would you please give me the expression or some more information that how can i indicate "from the beginning" and "end" when user entering his required period.
Thanks in advance.
Thank you user Mr. "mveijndh" for your reply. if i query short on date then date sequence is ok, but running sum calculation is easy based on sequential ID. so if you post a entry today (e.g. 27-3-2017) for back date (e.g. 1-3-2017), assume previous entry was 20,
so this entry hold the id no...
it is fine. its working. but ID is not sequential then? and I want to show report short on Date. so i need to calculate the running sum depending on date. and note that there are many same date record present.
then what will be the solution?
Question Summery:
>no sequential id (id present)...