How to produce daily sales for each item in a month of a shop using dbgrid. It should give how much numbers sold for each item in every day of a month. Pls help


You could filter the dataset and then read the desired itmes with the filtered criteria. Like filtering the "Soda" from 1.1.06 thru 1.3.06 and then read the sales on that period of time.

Could you be a little more specific on the explanation? maybe explain the fields and fields type of the table.

Hope it helps


Take one combo box consists of month values

after selection of month display datagrid in the formtaof

days in month in horizontal form
item and count of items in vertical form

2 3 4 5 6 7 8 9 10


1 2
Itemname count on ist count on 2nd

Like Wise

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.