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 Wanet Telecoms Ltd 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: *

  • Users: RSchnable
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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