Gianluca, thanks for the tip. I've been trying to convert our Access queries to sp's and views. This will allow me to translate the crosstab queries in Access. I think...

I'm thinking about a different route. I don't know what kind of "good" information can be contained in a +65K line Excel spreadsheet. I don't think people looking at that...

I think you've got 2 problems going here:

1) DTS/SSIS isn't installed on SQL 2005 Express Edition by default. You'll need to install the client tools from either SQL 2005 Developer/Standard/Enterprise...

Or you could use a SQL table (we'll call it 'Decision') with 2 values and 2 fields. 0 | False, 1 | True and use tinyint for the data type....

I agree with Scott (mostly). You only want to pull back records for 1 person (place or thing) instead of searching a table with thousands (consequently millions) of records. I've...

Try using a VARCHAR(length) for your SQL table field type.

I spent about 5 years doing just this task. I tried using the Upsizing Wizard for Access97, but found there were too many things that I had to manually change,...

I don't know the specifics of the relationship between Access reports and SSRS. I just usually put my SELECT statement into a stored procedure and then call the stored procedure...

So, if I have an asp (not ASP.NET) page (let's call it deals) that was displayed using a sproc and that url has the value I want to pass in...

Hence my reasoning for stating in my original post that this is not a table that will get inserted or updated very often.

Thanks Matt. Of course 10 minutes after I posted this, I figured out the multiple IF statement solution. Sometimes I feel like such a dork.

Hey homebrew, that works pretty good. I also got the email to work when I check for 1 field, but not for multiple fields. But what if I'm checking 2...

I was using BOL as a basis for my syntax, but it's not clicking for me. I don't understand what BOL is trying to say.

Thanks, David. I will follow your directions and see how that works.

Will do. I just noticed on the technet forum article that instead of using SQL Mail, I should be using Database Mail, as SQL Mail is going away. My company...