Hello
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

Recommended Answers

All 3 Replies

HI

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

Regards

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

Hi

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.