Search results

although i think not a good way of doing it but i used another 2 queries and put a subreport into my report and it worked

this is the sales header and sales details forms both have seperate tables this is the product and Bill of materials for each product also showing is the stocklist form all 3 have tables this is my purchasing form and header for any item is require to make the sales products both...

in the last few weeks i have tried to create an invoicing module within my database this is the report i have been trying to create to see if it all works ok or not below the are 3 orders of which you can see the first one there are 3 line items to invoice of which the system says i have the...

Thank you Expr2: IIf([paid]=True,[NET AMOUNT],0) works ok steve

Expr2 the second one just comes up with the word error . the paid column is just a tick box yes/no

the data below shows me what i have invoiced and what has been paid I am trying to return the net amount only if the invoice has been paid the 2 ways i have tried either give me all the same results ie net amount and exp1 even if the paid has not been ticked Expr1: IIf(Not...

yes thank you this works , but i will re design it iif(isnumeric([intcoterms]),[intcoterms],0) * Nz([exchange rate2], 1) thanks everyone for your help

just for information this also dont take into account the packing costs i just mentioned from the intcoterms field Order Totals by Customer Order Totals by Customer CustomerName OrderTotal GrandTotal Pct London Underground Ltd 548,436.44 1,646,245.52 33.31% GE Energy Power Conversion...

i know , i could not believe it when i started to check on all the work they are doing on this database as i thought i was for packing and shipment cost ( i now guess not ) so i was trying to do a quick fix until i can find out exactly what it is for . even if i have to put another field in...

i have changed the SQL but still got the error in " expri " field and yes i will change the feilds in the table . at this time i took a copy of the backend to test everything steve

SELECT [Order Details].BatchNo, Orders.OrderID, [Order Details].OrderDetailID, Orders.CustomerName, Orders.OrderNo, Orders.NCONo, [Order Details].ProductNo, [Order Details].OrderQty, Sum([OrderQty]*[Price]) AS OrderTotal, [Acknwoledge order].intcoterms, Orders.[Exchange rate2]...

hi, i have discovered that the sales people need to put a value or text in the feild called " intcoterms , i also see they have not been entering any date in that field also so i will default that to 0 what i am trying to do is add the "expr1" field value to the " sum of ordertotal field "...

hi , i have a sales form that has product numbers IE 1. FC1234M1 OR AB2345M1 which we are making and selling I Also have a stocklist form with all the parts to make any product we have now started to make extra products incase any go wrong for each order ie order is for 10 but we...

the form below shows me the 2 item i have purchased the middle sub form tell us what is received and in that form i tick the box " stock change " the form below that then changes the "on order qty" and the stock qty this is done by a query i have some vba that when i manually change the...

thanks to everyone for your help steve

no. it was a case of me not really knowing how to do it so i tried about 500 ways and got frustrated and that was one of them thanks steve

Private Sub report_to_file_Click() On Error GoTo Err_Handler Const FOLDER_EXISTS = 75 Const MESSAGE_TEXT1 = "No current product ." Const MESSAGE_TEXT2 = "No folder set for storing PDF files." Dim strFullPath As String Dim varfolder As Variant If Not...

Private Sub report_to_file_Click() On Error GoTo Err_Handler Const FOLDER_EXISTS = 75 Const MESSAGE_TEXT1 = "No current product ." Const MESSAGE_TEXT2 = "No folder set for storing PDF files." Dim strFullPath As String Dim varfolder As Variant If Not...

strFullPath = varfolder & "\" & Left(Me.Product_No, 2) & "\" & "Product Number " & " " & Me.Product_No & " " & "issue " & " " & Me.issueNo & ".pdf" strFullPath = varfolder & "\" & Left(Me.Product_No, 2) & "Product Number " & " " & Me.Product_No & " " & "issue " & " " & Me.issueNo & ".pdf"...

Private Sub report_to_file_Click() On Error GoTo Err_Handler Const FOLDER_EXISTS = 75 Const MESSAGE_TEXT1 = "No current product ." Const MESSAGE_TEXT2 = "No folder set for storing PDF files." Dim strFullPath As String Dim varfolder As Variant If Not...