Recent content by gard0128

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.