Search results for query: *

Is it possible to schedule a process to update a table right from Access? We are connecting a pivot table to an Access table, and would like to update (daily) the pivot table, without having to go into Access each day. We are running against a table (versus a query) due to faster processing...

We've got a customer email list, in Excel, that we'd like to import into Outlook. How can this be done? Thanks.

version 10 and yes I do

I am attempting to create a report that shows the last time a customer has been visited - by age categories (in days) - using the following data. Account Visit Dates Age of last visit Aged Category Acct 1 20050106 260 days over 180 days Acct 2 20050317...

thanks for all your help. report now works

got it to work....thanks for all your help

when I write this formula, I get an error formula name @int actual formula whileprintingrecords; numbervar intervalx; if onfirstrecord or intervalx<{@intervals} then intervalx:={@intervals}; When I test, I get the following message "A number is required here" - refers to (@intervals)

I get everything down to "Place this formula in the GH#1_b to act as a group name...." I've created the formula "if datediff"..., but when I attempt to place it in GH#1_b as the group name, I get an error. What I'm doing is going to header_b. I then click Change Group. I then go to the...

I do not have the option of adding a command in database expert

sorry...missed that. Initially, I used {Activity.ActualDate} in my formula. When I used {Activity.ActualDate}, I could group by this field, but the calculation was wrong since it wasn't always grabbing the last date, for each customer, from my data list. I then did a summary (maximum) on this...

field from the database {Activity.Actual Date} Formula's: LeadActvityAge DateDiff ("d",CurrentDate ,{Activity.Actual Date} )*-1 LeadActivityAgeCategory if {@LeadActivityAge} < 31 then "00-30 days" else if {@LeadActivityAge} < 46 then "31-45 days" else if {@LeadActivityAge} < 61 then "46-60...

version 10

I need to run a report that will pick up the last date a customer was contacted, and then group the report by categories (i.e. 0-30 days, 31-60 days, etc.) the data looks like this Customer id Date visited 001 20040101 002 20041231 002...

I have a list of repeating values. I am trying to count the number of salespeople in each region that have sales for a specific product. They only show up in the list if they have a sale. I am doing more calculation on this list, so I'd don't want to change the format of the list. Field 1...

I am attempting to do a distinct count of a list in Excel. Is there a function that handles this? Any suggestions are appreciated. Thanks.

I'm sorry. Not sure what you mean by "other toolbar" Could you please clarify? Right now, I'm creating a command button from the control toolbox.

I am attempting to create a command button and assign a macro to it in Excel 2003. I thought it was simply a matter of right clicking on the button and clicking Assign Macro from the pop up menu. However, this option is not included on the pop-up. What is the best way to do this? Any help is...

I've had this problem a number of times now. While I was working in my formula editor, my field tree became un-docked. No matter what I do, I cannot get it to re-dock. I've tried right clicking and clicking "allow docking", but it does nothing. And when I try to do this again, the "allow...

I am making customizations to the opportunities section of CRM. I have no problem making changes to the two main tabs ("general" and "administration"). The problem is when I attempt to make an addition to the "status reasons" drop list, that pertain to the "won" and "lost" radio buttons...

I am creating a report that will allow the user to run the report based on five different criteria using parameters. The trick is that I want all five criteria to default to "all" so that the user only needs to designate values in the field he/she wants to filter on. Is there a way to set up...