Search results for query: *

Thanks LB I appreciate it.

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

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

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?

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

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

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?

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.

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.

I guess I don't.

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.

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

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

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

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

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?

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

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