Search results for query: *

I have created a report that has a lot of lines per employee and what I am trying to do is suppress the details and show only the summarized fields in the group footer section. The problem is that when trying to insert a summary the formula field that I created is not showing up as a...

Thank you both for your quick response. It is nice for a newbie like myself to be able to get such great advice!

I am trying to set up a formula to calculate the first of the month after 30 days. So the field is called Benefit date let's say the value is 7/13/2006. I am trying to write a formula that will add 30 days (8/13/2006) and then display the first of the following month (9/1/2006). Any help would...

It worked perfectly thanks for the help!!!

Thanks for the quick response so that worked, but when I add in the Maximum (date) in the group footer it is giving me the maximum date that any employee took the course, not the maximum date that the specific employee took the course. So I tried adding this IF...

Hi All, I am on Crystal 11 and have a question about getting the date that an employee attended a training course. The training courses are on a different table than the employee and there is a one to many relationship between employee and training history. This is what the data looks like...

Hi All, Thanks so much for your quick responses Tom's formula worked like a charm! -----------------------------

I have an excel file with multiple worksheets and I am trying to have condition which returns different cells based on different criteria being met. This is the formla that I am trying to use: =IF(B6<='Pricing'!C3,'Pricing'!C5) (IF(AND(B6>'Pricing '!C3, B6<='Pricing'!D3),'Pricing'!D5)) I get...

I am on Crystal XI and I have a table that contains Dates that Team Members got a pay rate increase. Below is sample data: Employee ID Pay Rate Beg Date Pay Rate 13 01/01/1998 $7.00 13 02/05/2000 $8.25 13...

I have two tables (Employee & Positions). Table Employee ID Employee Name ================================= 9999 John Doe 9998 Jane Doe 9997 Sally Doe Table Positions ================================= ID EmployeeID Position Start Date Baker...

I am trying to convert a date that is currently stored as a timestamp to a string but I need to have it come back in the following format YYYYMMDD. Right now I am using the following CStr ({Table.Field}) this converts the field to a string but doesn't report it in the correct format. Any help...

I am trying to create my first fixed file format report using Crystal. The report is rather large and has about 100 columns of data. I don't want to print the file on a page, I just want to generate a file to send to a vendor. The previous reporting software that I used, I could have fields on...

Thank you both for your help with this. I do appreciate it!

Hi All, I'm new to using Access as a program to run queries. I used to use our old HRIS software, but now am forced to run queries through Access. So I have a table of Data which contains employees where each employee can have one row or as many as 20 rows of data. Each row of data contains a...