Recent content by kbrown73

Thanks for your suggestions...I actually solved another way. Since the checks will be written in order, I grouped by Check first, then manuevering the fields into the proper headings gets me the results that I need. Thanks again.

That works, thanks...

crystal 8.5, ODBC, Access Database How can I extract just the Date from a datetime field. I am trying to use the Datepart function, but it is returning errors... my format needs to be mm/dd/yyyy Thanks in advance.

Crystal 8.5, ODBC, Access Database I have a client (charitable) that assists their clients by paying utility bills in time of hardship. They will pay several utility bills with one check. I have created a database for inputing clients and their assists. While creating a yearly report for...

I thought that I tried that scenario. It works. Thanks...

I am trying to count the number of records in an Access database table based on double criteria. Here goes: child = DCount("[Status]", "[othersinhousehold]", "[Status] = 'Child'" And "[customerid] = " & "'" & ID & "'") "Status" is either "Child" or "Adult" "customerid" is based on the ID of...

Crystal 8.5, ODBC, Ingres DB How do you keep an entire group together. In other words, Group Header #1 Group Header #2 Details Group Footer #2a Group Footer #2b Group Footer #1a Group Footer #2b If there is not enough room on page for all of the above, don't print the GH #1, wait to print on...

I posted too soon. I solved my own proplem by using this: {start_time} = Currentdate - 1

BTW, the start_time field is a Date-Time field Ex: 11/4/2004 2:13:30PM

Crystal 8.5, Ingres Database, ODBC I need to setup a record selection that will generate a report for the previous day from a given time frame, say today is Nov. 5, I need the report to extract records for Nov. 4 from 12:00am - 11:59pm of a record field called "start_time". I do not want to...

Nevermind. I discovered the solution. Thanks for your help.

A little clarification: the * is for All and the ?Tool is for your example of ?Last_Name.

How would I incorporate a second parameter field into this formula for...let's say Date. I have the first half of the if statement...see below ( if {?Tool} <> "*" then {?Tool} = {ss_hist_base.tool} and {ss_hist_base.start_time} = {?Date} else if {?Tool} = "*" then true ) What about the else...

The formula editor does not like your formula. I receive an error message that the ")" is missing after the last {employee.lname} What is the purpose of the last "then true"?

If I do this, it will look for all last names that are "All". I have a list of tool numbers: 518 519 520 .... 725 When they select "All" from the selection screen, I want it to pull all tool numbers. Is there a wild card (*) character?