Search results

I'm free I can call now

First of, let me say this community is amazing. You have helped me solve one problem after another and really helped me learn, so I'm grateful for that. Now onto the next and hopefully final one. I'm trying to create a list of my products with an add button that will be unconnected from the...

I tried my file with @CarlettoFed and orders 1-2-3 were working fine, but #4 was giving him an error like me. The report opens fine but the ProductSum returns an Error! error. So I don't know how you mean that.

I’m sorry it was like 6am and my laptop run out of juice so I went to bed. There are two ways to solve it: 1) instead of the Dsum, just run a Sum(ProductCost) in the report on the ProductSum field. @CarlettoFed helped me figure this one out 2) instead of running a calculation I just added a...

run order #4. it's retail

I have teamviewer?

Anyway, I just used a =Forms! command to just reference the form instead of recalculating and it worked fine now But what you said is SO WEIRD!

What??? how is that possible???

It worked thank you so much.

scratch that only half solved. It accepts the first If but then skips the 2nd and jumps straight to the ReceiprR report. This is how it is now If Paid = False Then DoCmd.OpenReport "QuotationR", acViewReport ElseIf Paid = True & CustomerType = "Χονδρικής" Then DoCmd.OpenReport...

You want the OrdersF, OrderInvoiceR/QuotationR/ReceiptR (they are basically the same) OrderDetailsQ

I tried doing the calculation in the query but then I get another stupid error So in he query I created a calculated field and had my price draw the if from that field. The single product calculations work fine but the Sum field gets a Name? error Mind you I haven't changed anything else

Because I can't calculate all the retail prices without the VAT. They have to show as they are in their total When I input a new product I give it a wholesale-no-vat price and a total-retail-price, as it is in the website

it was a yes/no field. I know I shouldn't have used the "". They are gone now

worked thank you 😘

for a print invoice button. I wrote it in the vba

I have 3 reports printing for wholesale and retail customers When printing for wholesale everything is fine When printng for customers however, the OrderSum field (using a Dsum command) shows an error, even though the individual costs are all calculated correctly. In the relevant form it shows...

I seem to be blind but I can't find the error here. All it tells me is "Expected: =" but I don't think I'm missing one. Can you please tell me where I'm wrong? IIF("Paid"=False,docmd.OpenReport(QuotationR),IIF("Paid"=True & "AND CustomerType=" & "Χονδρικής"...

yeah I saw that. Thank you

I saw that and I went into the SQL too and saw you made it distinct. I'm not sure about the language yet but please help me understand Here: SELECT DISTINCT ProductDetailsT.ProductDetailID, OrdersT.CustomerID, ProductDetailsT.SKU, ProductDetailsT.ProductName, OrderDetailsT.DiscountPercent FROM...