Search results

@jdraw Here is the copy of database.

So, I tried everything according to my knowledge. Actually, if I do Quantity * Unit Price, it works fine but as soon as I add Quantity * Unit Price + IngredientPrice and run the query, it calculates as many as ingredients are there. I my case there are 29 ingredients. The screenshots are...

Thanks for all replies. I really appreciate that. Let me clarify the situation through a simple example. You go to a pizza place. They got one Pizza with 4 sizes and each size has its own price. Then you have the chioce to add extra toppings and the price for the extra topping depends on which...

Hello to all, I am making a database for one of my client and his products come with different sizes and extras. Each size has different price and the price of extras like cover, gift wrap etc. will also be according to the size of product. I made two tables. Product and Product Sizes and then...