Search results for query: *

I have: <b>parent_id &emsp;&emsp;action &emsp;&emsp;&emsp;&emsp; first_date&emsp;&emsp; latest_date</b> abc123&emsp;&emsp; BuyerPriceLockPrice__c &emsp;&emsp;&emsp;&emsp; 9/30/2019 &emsp;&emsp; 9/30/2019 abc123&emsp;&emsp; BuyerBasis__c&emsp;&emsp;&emsp;&emsp...

For column Assigned Kit, I am looking to input column M if the Total of Parent Item is a 1, if it is not a 1, I need to look and see if columns M:U match any Assigned Kit within the same SDDOCO range, and if not give me column M, if so give me the match. Row 2 should be DHRSKITA, 3: 5361KITA...

Hello, I have a Pivot Table whereby I am performing a running Percentage outside of the pivot table. The Table is as follows: Hub (grouped) Comp Desc Qty by Wk Total The running subtotal formula works for the 1st hub but not subsequent due to the hard reference to $AE$5...

Hello, I need to populate a summary page, from a different Worksheet range B2:BE2100. It looks like so: DSDSKITA/1 SMALL SCREW SYSTEM IMPL KIT Peak Demand Target Inv Cons Inv Trunk Inv Hub Inv Inv Net Inv ANAHEIM #REF! 0 0 0 0 -1 AUSTIN #REF! 1 0 0 0 0 -1...

Hi, My initial crosstab is as thus: TRANSFORM Sum([ct AllCallsAdjSurgDt].Quantity) AS SumOfQuantity SELECT [ct AllCallsAdjSurgDt].Hub_Name, [ct AllCallsAdjSurgDt].Kit_No, Sum([ct AllCallsAdjSurgDt].Quantity) AS [Total Of Quantity] FROM [ct AllCallsAdjSurgDt] WHERE ((([ct...

Hello, I have created a duplicates query that shows me exactly what it needs to, now I want to use the results of this query to limit another query, and I cannot get it to work: Here is what I have: SELECT kA.KitInventory_ID, kA.call_ID,kA.Kittype_ID, CD.Call_ID, CD.CASE_ID, KT.Kit_No...

Hello, I want to create a column whereby if the Updated_DateTime field is null, then convert the Created Date Time Field, otherwise, convert the Updated Date Time field and call it LastUpdatedDate. Can someone tell me why Im getting the following error: Msg 156, Level 15, State 1, Line 1...

Hello all, You are all always so helpful, I have a new question. I want to post a notice on the main switchboard of my db notifying users of the last time 2 of the tables were created or modified. What is the most efficient way to do this? Cheers, C

Hello, I have a query, whereby the end users have been inputting the date parameters directly into design view. I am wanting to convert to a parameter query, but when I do, any entry into the pop ups results in an ODBC call failed error. I have also tried a form for input with the same...

I have found many tips on how to sum with multiple criteria, but my question seems to be backwards. I have 2 separate worksheets. The first spreadsheet is a schedule with the following columns: Week # Product 1, Product 2, Product 3, Product 4 1 3 5 4 2...

I have taken over a couple of databases that are chock full of macros. I have never used them in my own databases as I have always been told that they are the bane of the existence of any Access databases. I took this at face value from trusted sources, but have never known why. So can...

Okay, I have 1 form with 2 subforms. I have an unbound combo box in the header that is designed to find a record on the form. If the item is not in list, the form should go to a new record and when the combo box loses focus it should go blank. I have 3 different code events and they are...

The above is exactly what I want to do. If the part number exists, I want it to pull up the record (I am successfully using an unbound text box for this), but if the part number does not exist, I want it to go to a New Record, and it just refuses to do that. Any ideas?

Okay, I have a date field in a form from a single table that needs to be "required". I have tried: IS Not Null, <>0 and <> "" in the validation rule of the text box. These do not work. I have also placed the following code in the Before Update and Lost Focus events: Private Sub...

Okay, I have a word document (.doc), I have also tried this as .dot. The document has a 5 lines on top that need to be filled in, and then a table for other information. The info in the tables is being added to constantly. Here is what I need to do. When a Row is inserted in the table that...

Here's the story. Created a Query (single table)with Begin Date and End date parameters. Have a Completion Date field and a Request Received Date field. In the Report I created two calculated fields. One for turn time Subtracting the Completion Date field from the Request Rcvd Date Field...

Here is my macro how I have it written: Sub Job_Title() If Field$("PS_JOB.DEPTID") = "0733118200" Then D = "CMP"+Field$("PS_JOBCODE_TBL.DESCR") Else D = Field$("PS_JOBCODE_TBL.DESCR") DERIVEDFIELD D End If End Sub I get the proper string on all other Titles except the one where the Field...

Hello, I am running a report that pulls pay changes, which it does just fine, until I add this Derived Field: (("A"."COMPRATE" - "C"."COMPRATE")/"C"."COMPRATE") which I need to calculate Percent Change. No, I cannot use the percent change field, as it does not serve the entire purpose...

Hello gtarrant, How exactly do you go about comparing something with the previous row? (see below) Thanks, Christine gtarrant (TechnicalUser) May 6, 2004 If you're working with ADP Enterprise, there is a field on PS_JOB named CHANGE_AMT. Any change to this field is an indication of a rate...

I read that ReportBasic is not Boolean, so how would I go about something to this effect: If Field A = X and Field B = Y Then D = Z Else if Field A = X and Field B = Z then D = Q