My greetings to all of you.
I need help from all of you with coding.
I have created a program which is made up of main form (offerentry) and sub form (greyshade). This is a program for a textile merchant to take orders for clothes. Customer related information is entered in the main form and shed and meter related to the goods are entered in the sub form. I have created seven blue colored boxes on the offer entry form. I want the first box to contain the total offers entered today ( Number of orders) and total meters should be shown.
In the second box, yesterday's date and the total number of offers entered and their total meter should be shown. Similarly, in the next blue box, if no booking has been made the day before yesterday, then the previous date and their total number of offers and their total meter should be shown. Similarly, I want to show the date of today and last 6 days, number of offers of those days and their total meter in all the seven boxes.
Please suggest me suitable coding for this.
Thanks in advance.