Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RSchnable

    Conditionalize the 3 Formula Trick

    Thanks LB I appreciate it.
  2. RSchnable

    Conditionalize the 3 Formula Trick

    Yes, the Total variable is being displayed in the report footer section. The following is the content of {@OrdTotal} IF OnLastRecord THEN ({BAQReportResult.OrderDtl.OrderQty} * {BAQReportResult.OrderDtl.UnitPrice}) ELSE IF {BAQReportResult.OrderHed.OrderNum} <>...
  3. RSchnable

    Conditionalize the 3 Formula Trick

    Hello all, I have a Crystal Report that totals orders for the month. I used the following code if {BAQReportParameter.Check02} = false AND {BAQReportParameter.Check03} = false then {BAQReportResult.OrderDtl.ProdCode} = "GUN" or {BAQReportResult.OrderDtl.ProdCode} = "TRE" or...
  4. RSchnable

    Looking to Outer Join more than 2 tables

    Thanks Bor...I was working on another query using a LEFT join and got it working, so I should be able to get this one now. And Sister, I assume when you say implicit syntax, you mean using the WHERE statement to get my desired results as opposed to using JOINs to link my tables?
  5. RSchnable

    Looking to Outer Join more than 2 tables

    I believe this is where this question should be. I have data in an external DB that I use Excel and Microsoft Query to pull data from. Here is my current SQL query. SELECT DISTINCT Customer_0.Name, CRMCall_0.SalesRepCode, CRMCall_0.OrigDate, CRMCall_0.CallText, CustCnt_0.Name...
  6. RSchnable

    Building Array in VBA with For Loop

    Ahhh. Just was missing a line of code somewhere else. Works great now. Thanks PHV!
  7. RSchnable

    Building Array in VBA with For Loop

    I feel like it's on the right track, but for some reason my filter only includes the last value in the loop. It does not include all checked values. Any ideas?
  8. RSchnable

    Building Array in VBA with For Loop

    I think so PHV, but just as when I tried using ReDim Preserve, I get Runtime Error 13 Type Mismatch error on the ReDim line.
  9. RSchnable

    Building Array in VBA with For Loop

    I was busy while I was responding to your posts, but after looking back, my question really has nothing to do with AutoFilter. I can populate a static array as my Criteria and filter it just fine. My question relates to how I add values, conditionally, to an array.
  10. RSchnable

    Building Array in VBA with For Loop

    I guess I don't.
  11. RSchnable

    Building Array in VBA with For Loop

    Well I guess I'll take a look at that. Any number of checkboxes, from 1 to 4, can be checked. When I used Record Macro, and checked 3 boxes, the autofilter recorded with the Array("Ron", "Dave", "Todd") method, so that's the reason I tried to build off of that.
  12. RSchnable

    Building Array in VBA with For Loop

    I apologize. The first array, arrFilter, is the collection of the checkboxes on my form. My goal is to loop through that array, checking if each one is true or not. For each one that is true, I want to add the corresponding value from the second array, arrField, to my final array, arrFinal. I...
  13. RSchnable

    Building Array in VBA with For Loop

    Thanks for responding. All arrays are dimmed as Variants. I hadn't included Debug in my code up to this point.
  14. RSchnable

    Building Array in VBA with For Loop

    Hello everyone, I have built a form in VBA for an Excel spreadsheet to search. I have 4 checkboxes, and if they are checked I want to filter on those names in a specific field. I have gotten this far. I can get one filter to work properly, but when I try to filter on 2 or more names, the array...
  15. RSchnable

    Selecting the First Record only

    Sorry with the slow response. I got pulled into some other projects. Really, there is no 'first' record per se. Because the ship date is unique, I get double the numbers I need. Whether I use FIRST, TOP 1, or whatever, I just need only one copy of the record. For now, I've removed the ShipDate...
  16. RSchnable

    Selecting the First Record only

    I'm not sure how to apply that to my code. The example I gave was just a snippet, but I have more tables and many more fields, as shown in my query above. Would that same principle apply to my code?
  17. RSchnable

    Selecting the First Record only

    Sure thing. Ship Date Job Num 1/08/2010 695 1.5 6.56 0.58 5.29 114.64 264.15 1/11/2010 695 1.5 6.56 0.58 5.29 114.64 264.15 As you can see, this record prints twice because there are unique ship dates for it, but all the data that I need is duplicated, so I only need the first...
  18. RSchnable

    Selecting the First Record only

    Hello everyone, I have a SQL query that I am trying to select only the first record from. The query is: SELECT ShipDtl_0.JobNum, ShipHead_0.ShipDate, JobAsmbl_0.TLESetupHours, JobAsmbl_0.TLEProdHours, JobAsmbl_0.TLASetupHours, JobAsmbl_0.TLAProdHours, JobAsmbl_0.TLALaborCost...

Part and Inventory Search

Back
Top