Search results for query: *

OK, I understand and thanks for the SQL Server Sargable information. Can you tell me why the portion of the WHERE clause above it works as it is from a similar crafted column. Where clause snippet: AND (PlanFunding = 'FI') PlanFunding defined snippet: CASE WHEN...

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...

MajP, Thanks, I appreciate your input and will give this a try soon. I agree with the sketchy. Unfortunately, I work for a business group in a large corporate structure, and I have been told to make a quick a fix as possible to the current design. Frankly I have two swollen ankles from...

MajP, Yes I agree that the design isn't what I would like, but I am stuck with trying to fix something without being able to do it correctly. I have taken you Function and incorporated it into my app. This works fine if in the query I use your sample code.. select fld, fld2,... from...

Duane, I wasn't clear at the bottom of my last post. I have two different form textboxes to acquire the criteria from, but each of those boxes are on different forms. I was hoping for a way to determine from the query object if the form was open.. use that forms value, else it would be the...

Duane, Yes, I was thinking I was going to have to do the SQL in VBA code. That is my backup plan at the moment. Since the query was already written as a MS Access query object and a report was already built upon the query as its source, I was hoping to save some time. The reason for multiple...

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...

Thanks All, It was a connection string problem. The string we use seems to work fine with SELECTS, INSERTS, UPDATE and other statements.. but wasn't working for the Stored Procedure. Our connection had in the string "Data Source = <Server Name>" once I changed the string to be "Server =...

Hello, Thanks for the response. I work for a company and unfortunately I am not in the IT department, but work for a business group so I do not have Administrator rights to the SQL server nor my own laptop. I will try to get with IT tomorrow to see if I can get someone who has the rights...

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...

All, Thank you, when I get to work on Monday I will put into place what I need to fix my issue! I think all was trying to tell me the same thing, but the light bulb didn't go on until I read the last post. Thanks much, AceMan1! I wasn't realizing that the function was seeing my whole string...

John, I misread earlier and understand you meant to alter the MaxofList function to accept a string. I guess my question is based on examples from Allen's site it looks like if you hand the following line it will process. MaxofList(#Date#, #Date2#, #Date3#) that it will return the max value...

John, Thanks for the reply. I am not that familiar with Arrays yet. I have vague knowledge of arrays at this point. I thought that my string is comma separated. below is the string I am entering inside the MaxofList(): strPlanDateValues = "#1/1/2009#, #1/3/2009#, #1/4/2009#" so it is...

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...