Search results

SELECT ProductDetailsT.ProductDetailID, OrdersT.CustomerID, ProductDetailsT.SKU, ProductDetailsT.ProductName, OrderDetailsT.DiscountPercent FROM ProductDetailsT INNER JOIN (OrdersT INNER JOIN OrderDetailsT ON OrdersT.OrderID = OrderDetailsT.OrderID) ON ProductDetailsT.ProductDetailID =...

you are wrong, I always study what you tell me

I'm a long way away from all that :( I don't even know how to edit sql or even where to look for it

I copied this as you wrote it but it didn't do anything I'm afraid I will need more explanation. I don't know this command

I still get the same problem. It won't even let me finish the line

I tried adding it in the criteria but I can't figure it out

I figured out I need a SELECT DISTINCT command to get the unique values, but I can't make it work. I keep getting an error saying "Case" or Syntax Error Also, I need it to use a combination of rules, so to select SKU+Discount Rate. What is the AND rule for this command? because I tried AND and...

Hey I have a button that opens a query with a filter. It's supposed to show me the customer discounts. I have the following conundrum. I could possibly have multiple orders of the same item with the same discount. I don't want to see all of them. However, this discount might change at some...

Ok so I recreated the whole database in English (minus a few greek labels) And I realised I was taking a detour, when I could just solve my problem with an IIF command. There is some problem with the math (math is not mathing lol), but I solved that too with another IIF command. In any case...

still the same problem

I tried that and I get this error and I don't know how to do what it asks.

So I have 2 sets of prices (retail and wholesale) and 2 sets of customers (retail and wholesale) I created an OrderPrice query so that it will recognise the type of customer and immediately draw the proper set of prices. So far so good Then this query I load on another query that has all the...

Thank you. This seems to have worked for now

The first one is to update the partial sum and the second one is to refresh the quantity I recreated the form and took it step by step. Tha main form works fine, it's the subform that has the problem. As soon as I input the subform and try to run it I get that error

Hey all So I have an OrderF form with a subform inside for order details. I have made a combo drop down menu here to show me my products. The combo box is taken from a query with only one table. When I go to create a new record, I put the customer's data, but when I go to choose the products...

Nevermind, fixed it myself :D

I don't know if this is connected to the first problem, but while you guys solved it so I can open it to a speficic record unfiltered, now it seems I can't register a new record through the forms

I needed it unfiltered to travel easily to each order I have placed with each supplier. The Where command, makes it filtered and I need to close and open the next one each time

Almost. I wasn't sure what the Recordsetclone did, so thank you for explaining :)