Search results for query: *

I am adding percentage values. These cells are NOT part of a pivot table but their values are calculated from pivot table cells. Option 1: =SUM(B22:F22)/5 Option 2: =(B21+C21+D21+E21+F21)/5 I then take the result from above and multiply this by a fixed value in another cell. The results...

We are using GP 9 Standard on a SQL 2000 Standard box. Single processor Xeon 3.06 with 3 gigs of ram. We have approx 25 GP databases running on this server along with 25 in another SQL application. It takes minutes to switch from one client to the other in GP so I'm wondering if there could...

I have an excel document that is utilizing various crosstab queries that are timeframe driven. Basically month and year. There are various months that have no data but I need the month to appear anyway. How can I force the month row to appear even if there is no data? 2005...

I am trying to sum/total/add (whatever) a perentage value. This value is being pulled from a query. Haven't been able to get this to work. 2.5 3.5 4.0 --- 10.0 Also, what is the easiest way to round a percent to a whole number? 2.4 = 2 and 2.5 = 3? Thanks, Dom

We're not a large company (under 100) and was wondering how most organizations handle the providing of PDAs or Blackberry type devices. Is this purely a company expense, shared expense or individual expense? Thanks, DomP

Using Excel XP(2002). I have prompts that work sometimes and other times the prompt screen appears without the text. It accepts the values entered so the prompts are actually working, it's just the question that is supposed to be asked cannot be seen. Any thoughts? Thanks, Dom

Can anyone tell me if Excel can handle a three dimensional pivot table? If so, can you point me towards some documentation on how to create this and/or a couple of quick tips? I'm having a bit of difficulty. Thanks, Dom

I have a number of queries that I need to run at once. Not sure if this is doable and/or the best way to accomplish this. The queries are independant of each other and have no relationship other than having to run one after the other. Bascially they are separate extracts that need to run to...

If you had to summarize the benefits and pitfalls of VOIP what would they be? And is VOIP much more attractive/compelling to organizations that have multiple sites compared to an organization that only has one site. Your insights would be much appreciated. Thanks, Dom

We are a company of about 80 people expecting to grow to 100 - 125 over the next couple of years. We are looking at the Nortel Meridian 1 Option 11C solution and was wondering what people who are knowledgeable about phone systems thought of this Nortel solution? Thanks in advance, DomP

We are a company of about 80 people expecting to grow to 100 - 125 over the next couple of years. We are looking at the Mitel 3300 ICP solution and was wondering what people who are knowledgeable about phone systems thought of this Mitel solution? Thanks in advance, DomP

We have an Access database linked to a backend SQL database. Can we create another Access database and link to the prior Access database? We want to setup a form/menu so people can run reports from the first Access database but didn't want to give them access to this database. SQL -> Access...

I'm accessing an SQL database via ODBC using Access. Without getting into all of the details has anyone ever seen a query return results that aren't visible in the query result itself but once exported or used in a subsequent query that data is actually there. The data is there but is NOT...

I have three tables (two that are linked via ODBC to a legacy system) and 1 other table. I am trying to have a user enter an ID number where the person and organization will appear based on a match. I've only been able to create a look-up where all entries appear and the user can choose from...

Is there a way to print the files shown in the windows explorer window or find files window? Thanks, Dom