Search results for query: *

Thanks for the help! I'm using Crytal Reports 2016 and I'm trying to set the value of a field to zero if the sum of FG_Trans_Qty doesn't equal the Invoiced quantity. The trouble I'm having is there are many variations in the shipping records. Most times there is one record for each...

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})

I'm using Crystal Reports 2016 and I'm having a problem with displaying the calculated running total in the report footer. As long as I don't Hide or Suppress the Detail or Group footer all of the formulas calculate correctly. If I Hide or Suppress the Detail or Group footer (which is what I...

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...

Unfortunately the output is the same as before. So here is what I've done. I added a Debug.Print txtOrgChange so that I could see what text the code is calling. So, here is the output from your code in the last post. [WC_Vendor] = 'CMV-KIT3XI' And OpNo = '60' And Job = '202550' [highlight...

Yes they are all on frm_ChangeEntry

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

Good Morning Andy, Below is the entire code for both cboJob and cboOperation as well as each cobobox's Row Source. cboJob Private Sub cboJob_AfterUpdate() Me.txtPart.Value = [cboJob].[Column](1) Me.txtPartRev.Value = [cboJob].[Column](2) Me.txtPartName.Value = [cboJob].[Column](3) End Sub...

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.