Search results for query: *

How can I change a negative number result into a posotive number in Crystal Reports

I have a simple update query: UPDATE SERVICES.dbo.MASTER SET DATEOFLEAVING = CONVERT(Char,b.DATELEAVE,103) FROM SERVICES.dbo.MASTER a JOIN SERVICES.dbo.EXITINTERVIEW b ON a.STAFFNO = b.STAFFNO When I run the query I receive the error message: Server: Msg 242, Level 16, State 3, Line 1 The...

I have a simple update query that runs as a job each evening.The query adds information from the Employee Master table to the Employee Leavers Table: UPDATE EMPLOYEE.dbo.LEAVERS SET JOB = JOBTITLE STARTDATE = CONVERT(Char,b.DATEOFJOIN,103) FROM EMPLOYEE.dbo.LEAVERS a JOIN EMPLOYEE.dbo.MASTER b...

I have a simple update query that runs as a job each evening.The query adds information from the Employee Master table to the Employee Leavers Table: UPDATE EMPLOYEE.dbo.LEAVERS SET JOB = JOBTITLE STARTDATE = CONVERT(Char,b.DATEOFJOIN,103) FROM EMPLOYEE.dbo.LEAVERS a JOIN EMPLOYEE.dbo.MASTER b...

My update query records the registration number, make and model of an employees company vehicle on his personnel record from a vehicle register where the switch CURRENT is ='T'(True) However, if the employee surrenders his vehicle for a car allowance I need to clear the vehicle details from the...

I have the following Update query. UPDATE ELYOSERVICES.dbo.CAREUSAGE a LEFT JOIN VBTGLOBALDATA.dbo.COMPANYCARS b SET VEHMAKE = MAKE, VEHMODEL = MODEL, CONVERT(Char,b.DATESOLD,103)AS LEASEND, (CASE WHEN b.FUELCARDNUMBER IS NULL THEN 'N' ESLE 'Y')AS FUELCARD, ON a.REGISTRATION =...

In my Access database users print reports to mail to suppliers about queries on invoices. I want them to be able to save these reports in a file and print them all together at the end of the day. I have created an output to file command button that saves the reports as a snapshot. Saving to...

This may seem a stupid question but I am very new to SQL. I have an update query that I want to run automatically each night at 11pm. Can anyone tell me how?

I have a SELECT query SELECT a.STAFFNO,a.REGION,a.DEPARTMENT, LEFT(REGION,3)AS REGCODE, LEFT (DEPARTMENT,4)AS DEPTCODE (DEPTCODE + REGCODE) AS ACCODE (DEPTCODE + REGCODE) AS COSTCNTRE FROM ELYOSERVICES.dbo MASTER a WHERE STATUS ='Active' Users enter REGION and DEPARTMENT from a pick list for...

I have created a select query: SELECT a.STAFFNO,a.REGION,a.DEPARTMENT, LEFT(REGION,3) AS REGCODE, LEFT(DEPARTMENT,4) AS DEPTCODE, (DEPTCODE+REGCODE) AS ACCODE, (DEPTCODE+REGCODE) AS COSTCNTRE FROM ELYOSERVICESTEST.dbo.MASTER a WHERE STATUS = 'Active' I want to change this so that it updates...

I have a SELECT query with a column called FUELCARDNUMBER. I want to create another column called FUELCARD which records "Y" if there is a fuel card number in the FUELCARDNUMBER column and "N" if it is blank. I have tried: IIF(IsNull [FUELCARDNUMBER],"N","Y") AS FUELCARD But this givs me...

I have two databases, EMPLOYEES and VEHICLES I want to run a SELECT query using tables from each database. I have tried using the full address to each table but this does not work. e.g. SELECT employee.details.surname, vehicles.companycars.model FROM employee.details INNER JOIN...

I have a report that runs from a command button on a form. The reportis based on a number of queries which question a linked SQL database. At the moment I use the buttons On Click event to run the queries as: Dim stDocName As String stDocName = "All" DoCmd.OpenQuery stDocName, acNormal...