Recent content by debbiepy

I send an Excel workbook to multiple recipients. My workbook contains getpivotdata and vlookups that refer to another workbook that I do not want to email to the recipients. How do I prevent the workbook from refreshing and causing errors to the recipient?

they are not dups. It is deals with multiple products. For example Deal 1 bought three products. I get the deal number three times but I still need the detail per product line in addition to the distinct count of deals.

How can I do this using a formula? I am not familiar with this

MS Excel 2007 I want to do a distinct count using a pivot table: Date Deal# 2/5/06 2 Result 2/5/06 2 2/1/06 3 Feb 2 3/1/06 4 March 2 3/1/06 4 total deals 4 3/5/06 5 I want to group by month and only count unique deals per month. How...

I figured it out. Our FY starts on 2/1/2007 not 1/1 so I added a parameter field to ask for the current quarter begin and put in suppression for division group section: Reportdate < CurrentQTRBeginDate and for my monthly selection I added month(Reportdate) <> month(today) - 3 The minus 3...

Actually it did not work it is only showing the top group of the division: QTR 3 MSD QTR 2 QTR 1 It is not showing ISD, BSD, etc.. for QTR 3 I want it to look like this: QTR 3 MSD BSD ISD QTR 2 QTR 1

Awesome, it worked. Now, can you explain to me why it worked. I hate doing something and not knowing why. I really don't understand this one and was expecting that it would not work.

I have a report grouped by Quarter then Division. I only want to see the division group for the most recent quarter but I want to see the quarter group for all quarters. QTR 3 200,000 GH1 MSD 80,000 GH2 BSD 20,000 GH2 ISD 100,000 GH2 QTR 2 300,000 GH1 QTR 1 150,000 GH1 How...

I created a form for my admin to enter employee information. THe control buttons on her view do not work but when I test the same exact database it works on my view. Using Access 2007 and the database is stored on the server. she accesses via this server. I have it set to default to the form...

I get errors if I do not put [] around the field name

I have a union query in Access 2007 that joins three tables into one. Where the fields do not exist in one of the joined tables I created this in the Select statement: "" AS [Product Name], WHen Crystal Reports XI grabbed the query from Access it created a parameter that looks like this: []...

it worked perfectly! Thank you

I have a union query in MS Access 07 that unions 3 tables into one. The union query has "" as OpportunityID for the two tables that do not contain an opp ID. The issue is when I perform a distinct count it sums all the blank into 1 distinct count in Crystal REports XI. How do I get the...

You are my hero! Thank you!

I set up my database to load a specific form upon start up and to hide all the options to modify it so that the end user cannot get into the settings. However, I cannot get to teh options now to change it back. Any clues? I am in Office Access 2007 but this is a 2003 database.