Search results

The results I have achieved using the queries we have worked on assumes that each employee has worked the full financial year. For example: Start Date Leaving Date ------------ --------------- 15/09/2003 19/12/2003 There is no way of calculating an employee's length of time within the...

Sorry me again!!! Have experienced some problems with the different types of data in various tables and have had to look at a different angle. would it be possible to base the number of months paid based on start dat and leave date? So for example: Start Date = 01/04/2003 Leave Date =...

I have a query statement: Final Tax Free Amount: IIf(Left([Final Tax Code],1)="k",Right([Final Tax Code],Len([Final Tax Code])-1)*-10-9,Val([Final Tax Code])*10+9) If I wanted to include: If final tax code = BR or NT then = 0. How can I add this to this statement? thanks

I have a column called Period_Number which relates to Tax month in the format: Period_Number Tax Paid to Date 1 12000 2 20000 3 30000 4 40000 and what I...

Following on from this statement. I wondered if you could advise me of something else. Surname Month Session Number Tax_YTD Year Employee x 12 2 1200 2004 Employee x 12 3 1450 2004 Employee y 12 2 1800 2004 I am pulling data from a table that has details on temporary employee's tax...

I am trying to convert an excel formula into a new access query statement. The statement itself will refer to a tax percentage column within the same query. Example of excel formula: =IF(Tax Percentage>22,40,IF(Tax Percentage>10,22,IF(Tax PercentageN2>0,10,0))) The output I hope to achieve...

Thanks for your help

Thanks Now receiving an error " Invalid Procedure Call".

The statement has been accepted: Expr1: IIf(Left([dbo_Payslip_Static_Data].[PAYE_Code]=[”k”],Right([dbo_Payslip_Static_Data].[PAYE_Code],Len([dbo_Payslip_Static_Data].[PAYE_Code])-1)*-10)-9,(Val([dbo_Payslip_Static_Data].[PAYE_Code])*10)+9) However when run an "Enter Parameter value" Box...

Thanks The expression has a function containing the wrong number of arguments: IF(Left([dbo_Payslip_Static_Data],[PAYE_CODE]=”k”, Right([dbo_Payslip_Static_Data],[PAYE_CODE], len([dbo_Payslip_Static_Data],[PAYE_CODE])-1)*-10)-9),(Val([dbo_Payslip_Static_Data],[PAYE_CODE])*10)+9) Have not...

This will used in a query. So I have column 1: Field: Code Table: Table Name Then column 2 will be a statement to say: If [fieldname] Code begins with a "k" then remove 1st character to the left If [fieldname] Code ends with an L then remove first character to the right If [fieldname] Code...

Thanks for that. I am trying to convert excel formula: =IF(LEFT(D2,1)="k",(((E2)*-10)-9),(IF(RIGHT(D2,1)="L",(((E2)*10)+9),(IF(RIGHT(D2,1)="T",(((E2)*10)+9),0))))) into an Access statement. Can you help?

Thanks for your reply Have tried this but receive an error: The Specified field '[PAYE_Code]' could refer to more than one table listed in the FROM clause of your SQL statement. Thanks

I have a column in access containing codes in format K2316 and wish to remove Prefix (K) from this code. How can i do this as a calculated field? thanks

Many Thanks for your reply. I have deleted tables from the database and relinked this seems to have worked. I am now updating queries and updated to new tables within the new server, but receive an error: The Microsoft Jet Dtabase engine could not find the object", Thanks

I wondered if someone could advise? We have recently changed our SQL Server and I am now trying to point an access database to this new server using ODBC connections. I have updated my ODBC settings and altered the name to the new object. It stills seems as though the database is pointing to...