Search results for query: *

I have some code that subtracts to items to get a result HRDIF and this code works fine until I add a where statement that asks to show only records wher HRDIF is >0. At this point I get an error "Conversion failed when converting the varchar value 'HRDIF' to data type int." How can I stop this.

I was told you can write the output of a query to a temporary table to be use again with some other query. How can this be done.

In access you can ask the user to type in a variable when the query starts that will be used to execute the query. How is this done in sql

Im creating a aspx page in ms sharepoint designer and I would like to know if there is a way to hook up a button to activate an sql query in a microsoft sql database.

I want to create a table with an sql script that will take only some values from another table. How can I do this.

I need to update a field in one table "Work" based on a value in another table "Job". The two tables should be linked by the field "job#". I want script to update a field "status" in table Work based on the value of "status" in the table "Job". Can anyone please help me on this. Thanks in advance.

I need to output a value of 0 for COSTDIF whenever PMCATGT.COSTTYPE is = LAB in the following program but I'm not having any luck. Help is much appreciated. Select PMCATGT.CONTRACT,PMCATGT.PROJECT,PMCATGT.COSTTYPE,SUM (PMCATGT.CURQTY) AS BUDGETHRS,SUM (PMCATGT.ACTQTY) AS ACTUALHRS,SUM...

I have a query that produces a form and I would like to have the query put out a column that basically subtracts one column from the next. I would like to create a field that subtracts SUM (PMCATGT.CURQTY) AS BUDGETHRS from SUM (PMCATGT.ACTQTY) AS ACTUALHRS. I can't get this working. My code is...

I would like to generate a specific title on a report that is dependent on a value of a field in the report. So if a value of 30 comes up I want the title to be "OPEN" and if the value is 60 I want the title to be "CLOSED".

I would like to pull data into a report from an sql query but not sure how to make the link. I'm using sharepoint designer to generate web reports but I can only connect to tables. How can I start the query and access the data from the query to go into the report?

I have two tables that have relationships established but when I query the data it is as if the relationship does not exist. Do I have to restate the relationship inside the query?

I have created to queries and from two diffent databases and saved them. SQL saves them in the project folder. How can I create a query that uses the results of the two queries?

How do I add an page to sharepoint for looking up data in sql

How can i get the user level security set up on an access 2003 data base to work in access 2007

I recently purchased a newlap top with Microsoft Vista. I use to be able to go on the sharepoint web (located on a server 2003 Server) open the form template fill it in and submit it to an sql database. Now I'm not able to open the form. I get on the sharepoint site ok but when I try to open the...

I'm creating a form in infopath that is hooked up to an sql table. I would like to have a field for an attachment in the table. What datatype is an attachment file.

I have a data base for a form that is created by one user and passed on by another user for approval. What can be done to lock the record once it has been approved by the second person

I'm trying to create a form in Microsoft Info Path that is attached to an sql database and I would like to have it digitally signed;however in Info Path it says the following: When designing a form, you can specify whether or not users are able to use digital signatures (digital signature: An...

Every time I try to add or change some fields in a record I get the message that the record is opened by another user but there definately is no one else in the database.

I have some code that creates pdf files for quotes based on a range set in a form. Right now i write out the pdf files using the quote number as the file name. I get the quote number from the form. I would like to be able to also add the customer name to the pdf file name. How can I generate...