Search results for query: *

I'm very new to crystal, SQL, VB, and Access. I'm not really sure how to format a formula I have an input from access into my report and i need to create a formula that will say if this field equals a 1 or 3 add 1 but if the field equals 2 or 4 add .5 i know it's simple but any help would be...

I have created my report though a wizard and have nearly completed its design and have now realized i need to add another field which i did not import when i went though the wizard. Is there a way to add a field from the same access database you are currently pulling from?

What i've done is i've created a report that contains ton of data on my employees for a quarter. I now want to rank them. I've created a sub report and have imported the names and branch offices of my employees from access into that subreport. I now to need too bring a % value that was...

I'm running Crystal Reports XI. My report is essentially a ranking of employees. Currently they are sorted in Alpha order by name of employee. There is a calculation that takes place and gives a weighted average of 3 Percentages. This is part of the Detail area of the report for each employee. I...

I have an employee list and i need to make a query so that if a name in the employee list is not listed in another table then to append it...how do i do this?

I'm fairly new to access and i'm not sure how to do what i want but this is it... I have revenue values that employees are credited with and my company creates a ranking report for them. What i need to do is take a record which is similar to this: Date Employee Office Loan Amt...

I'm trying to call a value from another table into a field on a form. Below is my code...I'm getting a "Argument not optional" error Me![BM%] = IIf(Table.[Employee Data].[Office] = Me![Office], IIf(Table.[Employee Data].[Title] = "Branch Manager", Table.[Employee Data].[Commission %], 0))

I have a database which houses both an employee table(that has employee names, SS#, commission %, branch, etc) and another table that is used to enter loan information and the employee is selected that has assisted the customer. In a form I have a combo box referencing the employee table to...

I'm trying to calculate a managers commission and i'm trying to bring forward their commission percentage from their record after searching all employees for the constraints of their title = Branch Manager and their office = office listed in the current form. The office is listed in a combo box...