Mr

[Abdulaym]

Hi, pls I have a Combo box "Productname" which contains list of items like buscuits, sweets and milk. With the quantity sold. How do I get the quantity of buscuit, sweets and milk sold through query or any other means. Thanks

[Welshgasman]

Look at the Group BY clause and SUM() on quantity field.

Get yourself on to Youtube and look at some videos.

https://www.youtube.com/results?sear...m+access+query

[June7]

Get them where? This quantity value is included as column of combobox or do you mean quantity is a textbox on form?

A textbox expression can reference combobox column by index. If quantity is in second column, its index is 1: =[Productname].Column(1)

Build a report and use its Grouping & Sorting features with aggregate calculation in textbox. This allows display of detail data as well as summary info.

[Abdulaym]

Thanks for your reply, the quantity is a textbox, while buscuit, sweets and milk are in combo box. You mean the column where the quantity is in a table or subform? Thanks

[Abdulaym]

Thanks for the reply

[Abdulaym]

Hi, I have a query which I used for my report. the reports gives me the quantity of each product I sale and their total. But my question now is that; I want a daily reports I.e. todays report should not mix with tomorrow report? Thanks for your usual assistance

[Welshgasman]

Hi, I have a query which I used for my report. the reports gives me the quantity of each product I sale and their total. But my question now is that; I want a daily reports I.e. todays report should not mix with tomorrow report? Thanks for your usual assistance

Group by Date as well then.

[mike60smart]

Can you upload your database so we can see your table structures?