Hello everybody -

I'm trying to query fields that have any of the 4 revenue types that we track greater than $249999.  When I build the query with the wizard it defaults to AND, so I'm not getting rows that have just one of the 4 revenue fields meeting the criteria.  Currently I've built 4 different queries to get this, but then when I pivot I get duplicates, etc and it's just not a clean report.  How do I adjust row 1 in the query spreadsheet to reflect the OR function? 

Thanks for being such a resourceful forum!  Have a great day.

Brent A

System Specs: Office 2007 on Windows 8 64-Bit

I'm able to connect to my sf just fine and see my custom objects, etc. When I run through the wizard and leave the Clause page blank it returns all of the records in the object just fine. The same goes for when I limit using number fields.

But when I put any type of limiting criteria that involve date fields, text fields, or picklist fields on the Clause page it returns 0 records.

For instance in both picklist and text fields I've tried using double quotes (Example = "In Training"), single quotes (Example = 'In Training'), and no quotes (Example = In Training). All return 0 records when I know that there are records that have the text "In Training" in this field.

Am I doing something wrong with entering criteria? Can someone please help provide a couple examples of successful query clauses that limit text, date, and picklist fields?

Thank you in advance!

I've been trying to use the Excel Connector for the last two weeks to manage the data in our organisation, but I'm having a problem where I get the following error in Excel which is preventing me from using this tool:

Error Generated by request::An internal server error has occured while processing your request.
Url:https://www.salesforce.com/services/Soap/c/13.0

ExceptionCode : 5103

The first couple of times I tried to use Excel Connector it worked fine. However I then started seeing this error every time I tried to use it - the error appears after I put in my password in Excel Connector and click Login.

We are on Salesforce Professional. I have tried uninstalling and reinstalling the toolkit and connector, but it hasn't made a difference. I'm using Excel 2010 32-bit on Windows 7 64-bit.

I can log in to Salesforce in my browser on the same computer.

I've checked that IE is not in Offline Mode, and verified that Excel can actually connect to the internet (pinged a URL using VBA script).

I've tried disabling my antivirus (MSE) and windows firewall.

I've tried changing the server url as suggested by this thread (had to modify registry keys to do this as that field was not editable in the connector.

None of these resolutions worked.

Has anyone experienced and managed to resolve this, or can anyone suggest any other possible resolutions?