Search results for query: *

Thanks, Skip. Call me an idiot (I'm still learning Office 2007 vs 2003), but I can't find the "Add Tables" Window. Where should I be looking?

First, thank you in advance for your assistance. Here's what I'm trying to do: I have two sheets in a workbook which I need to combine. I would normally just use vLookup to pull the columns. However, in this case, Sheet2 has multiple rows that correspond to one row in Sheet1. e.g: Sheet 1...

lbass - That's exactly what I ended up doing. He originally wanted it sorted by only a certain product, which was driving me batty. :) But, since he wanted it sorted by ALL products, he made my life ever so much easier.

Never mind ... the user changed his needs/wants and made it much easier for me. Thanks anyhow. :)

I tried to search for this, because I'm sure it's been answered, but the google search didn't produce anything useful. Any help would be appreciated. I have a report with the following: Group 1: {year} Group 2: {Client Name} Group 3: {Product}, {Distinct Count, Sale ID} Detail (suppressed)...

Well, you've done it again! Thanks so much for your help! I can only stand in awe of your knowledge (and ability/willingness to use it to help others.)

Soryy, yep, in the crosstab. The user who has requested the report also wants to see the profit shown as a percentage - so in the regular report, it would be this formula: ((gross - net) / gross) * 100 But I don't have a clue how to represent the ((sumgross - sumnet) / sumgross) * 100 in...

Gah ... one more question. I need to sum up a percentage ... how do I get that to show up accurately?

Thanks ... I knew it was something simple that I was missing. :)

I don't think I expressed myself clearly. Sorry. What I want is to display a summary of all job types for each year .. so the above columns (which are net, gross, and profit) would display a sum. So the whole report would look like this: GH1: 2007 ({JobDate} - sorted and grouped by year)...

Working in CR9 ... I have a report with three groups: Group 1: Date (by Year) Group 2: Job Type Group 3: Job What I want to do is put a summary of the totals for the year, listed by job type, in the GF1. So the footer would look like this: GF3: suppressed GF2: suppressed GF1: Job Type #1...

Okay ... here's my problem. I have a user (okay, myself) using an ODBC connection to access the MySQL databases through Crystal Reports 9. (Windows XP SP2, all updates) When I try to do this, I get the following error message: Logon failed. Details: 28000:[Microsoft][ODBC SQL Server...

FYI, I did end up using =d2-(1/24) ... kinda a combo of the original help-posts to end up with the third. :)

Thanks! This was just a "duh" moment for me, I think. Occasionally I need hit upside the head with the obvious. :) (Why is the hard stuff so much easier? I can write vlookups for hours without problems. Heh.)

I have a CSV, which I open in Excel 2007, containing a list of events, with their start times and end times. However, the start time and end times are in Eastern Time and I'm Central time. Before I can upload this list into Outlook, I need to change all these times to be minus 1 hour. An...

Here's one I heard from a SWA pilot. It made me doubt his qualifications to be flying the plane. :) "Okay, folks, the weather in Nashville is 56 degrees and overcast. However, if you ask me, it just looks cloudy." Um ... SAME THING, Einstein!! Yikes!

First, your pst solution is pretty much exactly what I did for a temporary fix. However, right now I'm at the "figure out why" stage ... It does indeed have an error message. Sort of. It says: "Cannot expand the folder." Which I find to be *exceptionally* helpful. :)

Okay, so how do I approach the management with this issue? I'm a very non-confrontational person (particularly with my "superiors"), so is there any TACTFUL way to cover this? Do I just say that I'm peeved? Do I approach it as a "it's not you, it's me" kind of attitude? I was thinking...

Hi! As sole IT person for a small business, I have primary responsibility for the well-being of computers. Besides my primary desk, I have a separate area for computer storage and repair - which is overflowing at the moment because of a office consolidation. However, its organized (my way)...

Hi! I have an interesting problem - hopefully someone can offer a solution. We are running EX03, fully patched. We recently had a bit of turnover in the company, so I have been asked to allow the covering employees access to the email of the folks who have left. Until today, this had gone...