Some Questions

[Hello1]

Hello guys!
I got one question. On the next picture u can see 2 tables (Seller and Orders) and the relationship between them. Now in "Seller" table in field "Number of sold phones" I would like access to count how many times is Sellers name and surname mentioned in the "Orders" table and then to put the number in "Number of sold phones". So, is that possible and if yes, how? Thanks!

[ItsMe]

You can create a Totals query by clicking the Sigma symbol in the upper right corner from within the Query Builder. Add fields from your table to the grid at the bottom of the designer window. You can add the Count() function to the desired field by changing Group By to Count.

The trick here is to add only the fields that will affect the unique count desired. You may need to add subqueries to combine different count values. Another approach is to use a Report.

[orange]

Further to ItsMe's response, here are a few things to consider:

-embedded spaces in field and object names will lead to syntax errors. It is better to use a naming convention that does NOT allow embedded spaces or non-alphanumeric characters in names.
- in a typical Seller/Orders/Items data base set up, you would have an Order and OrderDetail table

It seems you may be missing a table(s) since you would normally be Selling to a Customer/Client

Seller ---->Customer--> Order---->OrderDetail<-----Item/Product