Search results for query: *

...then {Invoice_Detail.Amount} else if {@MatTransReverse}<>{Delivery.Shipped_Quantity} then 0 else {Invoice_Detail.Unit_Price}*({Material_Trans.Quantity}*-1) This formula works for Case 2 but not for Case 1 because in Case 2 the Shipped quantity is equal to one of the invoiced lines. In Case 1...

Thanks fisheromacs, Your suggestion worked! I had to change the structure of the report but it works so that's the important thing! Brad

Thanks for responding! I think it's correct too, that's why it's driving me crazy. Below is a screen shot of the main formula. Here is a screen shot of the Main Report. The Unit Price field that is suppressed is from the Job table. The Unit Price I'm using in the Subreport is from the...

Hi Everyone and thanks for your help in advance! I'm using Crystal reports 2016 and I'm having a problem with passing a shared variable. Oh the subreport "Sub-PartActInv" I have the following formula which passes the Unit Price to the Main Report. Here is the formula for the shared variable...

I'm using Crystal Reports 2016 (32-bit) and trying to connect to spreadsheets created in Microsoft 365 (64-bit). The original reports were created with CR 2016 and Microsoft Office 2016. Now that we've updated to Microsoft 365 the Microsoft Office 12.0 Access Database Engine OLE DB (ADO) is no...

Thank you lbass, that works perfectly! I did make one change because I want to hide the detail section. I moved the subreport to Group Footer 2. Thank you for your help!!

Sorry everyone, I noticed this morning that I posted the same formula twice. The formula for the Scrap Cost for each line is wrong in the above post. Below is the correct Scrap Cost for each detail line. (({Job.Est_Labor}+{Job.Act_Material}+{Job.Act_Service})/{Job.Make_Quantity})

...cost for each detail line, whileprintingrecords; shared currencyvar ScrapCost := scrapcost + (if {Job_Operation.Sequence}=0 then ({@LineCostEa}*(({Job_Operation.Sequence}+1)/({@Pass_JobOpSeq}+1)))*{Job_Operation_Time.Act_Scrap_Qty} else if {@Pass_JobOpSeq}=0 then...

Andy, Thanks so much for your reply. I found the issue with the SQL statement. Because the tables are linked to the Access database the table name has a "dbo" prefix which of course isn't needed in the SQL statement. Below is the code that works. SELECT Employee.Employee...

Andy, Thanks for the reply and suggestion. I've fixed all but one error which I don't understand why this error is coming up. Below is the second version of the code. The reason I didn't use your suggestion for the DateDiff is because it's a DateTime field and some of the entries are only...

I'm working with Access 2016 and SQL 2012. I'm trying to convert the following query from Access to SQL but I keep getting errors. I've listed the statement and the errors below. Any help would be very much appreciated. SELECT dbo_Employee.Employee, dbo_Employee.Last_Name...

WOW!!!! Thanks strongm and Andy!!! It actually works as expected!! Here is the wining code Private Sub cboOperation_AfterUpdate() With Me.cboOperation Me.txtOPNo.Value = .[Column](2) Me.txtSetupHrs.Value = .[Column](3) Me.txtRunRate.Value = .[Column](4) Me.txtRunType.Value =...

Andy, How is your Note_Text field defined in your dbo_Job_Operation table? Note_Text's Data Type is Long Text with a Text Format of Plain Text So if you do this request in a SQL view of a query: SELECT Note_Text FROM dbo_Job_Operation WHERE Job = "202550" AND WC_Vendor...

...CLAMPS & ADD BOLT THRU CENTER" SEMI FINISH 4.0935 DIA. TO 4.123/4.125 DIA. X .373 .375 DEPTH WITH .020 .020 CORNER RAD. & CHAMFER .030 X 45 DEG. **************************************************************************** 1ST PIECE ACCEPTANCE: STP/INT:______________________...

Yes they are all on frm_ChangeEntry

Still the same problem, Note_Text is not the correct value.

...Me.txtRunRate.Value = [cboOperation].[Column](4) Me.txtRunType.Value = [cboOperation].[Column](5) If Len(Forms![frm_ChangeEntry]!cboJob & "") * Len(Forms![frm_ChangeEntry]!cboOperation & "") * Len(Forms![frm_ChangeEntry]!txtOPNo & "") = 0 Then Me.txtOrgChange.Value = "" Exit Sub End...

Andy, You either have all of these 'double' controls on the form, of you should have a whole lot of syntax errors while running your code. Before I copied and pasted your last suggestion I had changed all the references to comboboxes to be cboNAME. Unfortunately it didn't seem to correct the...

Ok, so I copied and pasted your entire code, saved it and then closed the form. I opened the Form and selected Job 202550 and then Operation CMV-KIT3XI which is OpNo 60 but the text that was populated into orgChange from Note_Text was from Operation CMV-KIT3XI, OpNo 10. I don't get why it's...

I tried that but I will try it again. I thought it could be a timing issue.