Recent content by edmac2

Never mind I finally figured it out, just had to have the right fields to work with!

Crystal 6.0, I have a field {WORKORDER.REPORTDATE}and another field @Date that gives me a number. How can I add the 2 fields together to increase the {WORKORDER.REPORTDATE} by the amount of days stated in the @date field. I tried if {@Days} = "1" then {WORKORDER.REPORTDATE} + 500...

I have a text box that I would like to enter a date in, when I do I would like to have an option group that contains 2 options used and unused make the used box active, if I remove the date I would like the unused box active, is there a way of doing this with Access 97?

I tried this but it does not find the last records at all that deal with the 1/2Days {Employees.Day1} in {@StartDate} to {@EndDate} or {Employees.Day2} in {@StartDate} to {@EndDate} or {Employees.Day3} in {@StartDate} to {@EndDate} or {Employees.Day4} in {@StartDate} to {@EndDate} or...

I am trying to figure out how to search a report that I have 26 field that are dates. I would like to be able to just have the records show up that are within a date range. I have done it by 1 date before, not sure how to cover all 26 dates though??

I use Crystal Desk to print out my reports, is there a way to have a report not print out anything if none of the data you were looking for is not found, right now alot of my reports contain text followed by the information being looked for, depending on the time of month when the other reports...

Crystal has a way to suppress duplicates, Is there a way of only showing duplicate fields?

I have a crystal6 report that accesses an oracle db. This report uses a subreport linked by the equipment record which is the only field available to link on. I have the subreport suppressing if the item field is null but the equipment record still shows up and takes up space on the report. Is...

Thanks Ken this is exactly what I was looking for.

Ken I use the date as a parameter field to search a report for records between 2 dates. I just wanted to know how to input the dates so crystal could use them. Presently I use if {?Start Date} = "" then PrintDate Else If NumericText(Left({?Start Date},2)) = True Then if...

What is a good formula for dates in using to search a report. The one I presently use requires the mm/dd/yyyy. Is there one available that would allow mm/dd/yy. What are some of the ones you experts use, the more selections the better. TIA

Is there a way of formating a positive number to have brackets around it as ($100.00)

Got it Thanks

Crystal 6 I have a field that consists of names as McCormick Ed. How would I be able to make this into 2 fields say FirstName, LastName.Each Name has a space between first and last name or just be able to split it up so I could get the first name or the last name in another field.

I solved it just had to go 1 more step, Thanks