Search results for query: *

You're dead on again, Skip. But formulas outside the PT are rendered useless as soon as filter options change the layout of the PT results. I just don't think I can get the best of all worlds ... the flexibility of the PT PLUS the power of complex functions. I appreciate your help.

Skip, I use those functions now. How does one use those in a PivotTable? As far as I can tell PT's do not provide that kind of formula insertion ... so that I can utilize the PT flexibility, while also getting the analysis from the functions you suggested. Is it possible? Thanks, again.

Sorry ... don't know how to attach a file. The 8 cell example is really exactly the source data to work with. Goal stated in words ... which I can do outside a PivotTable ... but trying to take advantage of PT flexibility ... Count all the lead records Count only the sold results Show me the...

Simple data setup ... each record is a sales lead. Each record includes a result column - sold or unsold. Simple example might look like ... Lead Result 6/1/10 Open 6/2/10 Sold 6/3/10 Sold 6/4/10 Unsold I would like a "report" result like this ... CountOfLead...

Thanks Remou. That's over my head just looking at it, but I can play with it to see what happens. Then I'll understand it.

Yes. That helps. At least it cuts the typing in half. I only I have to type the field list in once instead of twice. Thanks!

I want to duplicate a record in the same table - all the data except the key field, of course. The append query is easy enough. For example, here I am duplicating record #2 in my test table called zzTblJunk: INSERT INTO zzTblJunk ( Field1, Field2, Field3 ) SELECT zzTblJunk.Field1...

Your explanations make perfect sense. And I know from putting your solution into practice it works fantastically. My indexes were already in place, but I did add the "Top 1" syntax to speed things up even further. Thanks, again. I learned a lot from your posts! Joe

Golom, Thanks for the code. I like it, and will be able to use it in other settings. Joe

My thoughts WERE (when I first read it) ... I understand the goal, but how does what you wrote achieve it? Still, I plugged it into my live data, and it works. Thanks a million! I'm still trying to get my amateur brain around why it works. It seems like a "double-negative" ... looking for...

Hello Amazingly Smart People, I did a search and found the answer to my question. However, the answer is excessively slow. I'm wondering if you know a better way. Need: To delete records from TblA when the key value of the records does not appear in several related tables. Solution: DELETE *...

That's it. Thanks very much. Simple, but unknown to me. Thanks again, Joe

This seems like it should be simple, but for some reason it's not (for me) ... Table1: RecID Client 1 A 2 B 3 C Table2: RecID Client 1 D 2 A 3 E As you can see Client A appears in both tables, but the other clients do not. How do I query the Client value...

Thanks Jerry, As it turns out, when I took Duane's ideas to the real situation I realized that there will always be some kind of sale in any month. Therefore, the cartesian query that sets up the agent and month combinations does not filter for type of sale. That way I'm guaranteed to always...

That's great, Duane. Thanks! I can tweak that to the reality of my situation. Now ... what if there aren't sales in every month? In that case the cartesian query cannot include that month, and so I will have a missing month for each agent instead of a zero month for each agent. In reality...

Let's say I have a simple sales order table like ... SaleID Agent SaleDate 1 A1 7/6/07 2 B2 7/25/07 3 A1 8/12/07 4 C3 8/14/07 5 C3 9/6/07 6 A1 9/10/07 And I want to count each agent's sales within the quarter by month. This...

First, you're headed in the right direction. When I drag and drop an email onto my memo field all I get is the header of the email, too. That's why I put my code in the Dirty event of the field - to trap that event and do what I want to do. Make sure you're using the On Dirty event of the...

Bill6868, Here's how I fleshed out Remou's code idea for my uses. I moved the code to the dirty event so it runs the instant the user drops the email onto the memo field. What the code does is makes a copy of the email in a network folder. Instead saving as a text file I'm saving in msg format...

I think I'm at a dead end with this. The article itself says "this procedure may not work in some circumstances". And it also talks about conditions under which "garbage characters" will be returned - which is what I get in my database. I went through the procedure with the Northwind db as...

Hap007 & Remou, This is awesome. It looks like we're on the right path. The code you posted Remou returns what I would call machine language jibberish, or I get errors about the field being too small. And when I follow it in debug the str variables have the machine language jibberish in them...