Search results for query: *

Hello All, I have a lengthy SQL statement that runs fine until I use a column name in the Where clause which causes an error of Invalid Column Name error. If I comment out the line in the where clause that uses this and run it completes without error and when I look at the results the column...

Hello all, I have a query that needs to use a value in a form as it's criteria. I know this is simple, and I have that part working. What I really need the query to do is look to see the value from the form, if it is not open or null use a value from a second form. I tried this code in my...

Hello all, I am using SSRS 2008 and have created a report with various charts and graphs based on data from a dataset. The report is giving all of the users what they want, but they were wondering if they could have the rawdata returned from the dataset query pop-up when they hover over the...

Hello, This is my first time trying to create a recordset from a SQL Server Stored Procedure. I expect one record returned with about fifteen columns. I will then take the columns and populate a form's textbox with the value or a null. When I get to the IF loop I get the following error...

Hello all, I have a problem that in my code. My code creates the string I need fine, so I am going to abbreviate the code to illustrate my issue. In my code I have run a query that gives me 1 to many rows in a recordset. I then determine between two fields which field for that row represents...