Search results for query: *

Looking for a simple formula to show all the days prior to current month... TIA.... Jen Jedder

Using Access07 Created a subform where users enter data. Have an autogenerated number field in the table. Scenario... The first data entered will show on a main report. ANything after the first record needs to show the info on an additional report. Is their something I can put in the criteria...

scenario clients who <= {@enddate} clients have null value for @dischdate or clients who <= {@enddate} client have value in @dischdate between @startdate and @enddate I need clients who fit either scenario to show on report Help Please! Jedder

Using Access 2007 Windows 7 Using this code to find duplicate client ID and have message popup. Keep getting error on If clientidTemp line saying cannot find the client info form... That's the name of the form. Is it because of space in title or the form does have 3 tabbed pages on it. Do I...

Using Access 2007 Windows 7 Have a form that has 3 tabbed pages On page 3, would like to insert a command button to add/close this record and move back to page 1 of same form to start a new record. macro? expression? Suggestions? Jennifer Jedder

CR Ver 8 Report group1 by name group2 by week(date field) Detail detailname detailsvc datefield time duration I'm trying to sort the date in the detail ascending keeps sorting by detailsvc have only 1 sort select which is datefield Is it possible to sort the same field by group...

Can you use an * to find data returned for all instances i.e. MHCOU01 MHCOU02 MHCOU03 if {service.code}= "MHCOU*" Thanks much. Jedder

Using Crystal 2008 3 groups group 1 = Staff name Group 2 = Date group 3 = service Group 3 could have many different versions of services by Staff name (group 1) I'm searching for a way to total all these services(group 3) in 1 section as opposed to totalling after each change of service...

Crystal V 2008 Have a report Group 1 = person we pay Group 2 = rate we pay them Detail a = item we pay group 1 for, group 1 has code attached to them, by date range detail B = item we pay group 1 for, with different code What is happening...Group 2 is showing up 2x for each rate (the...

Using Crystal 8 {text_Value}= "No" or trim({text}) = "" or {text2_Value} = "No" or trim ({text2}) = "" Have a text box and suppressing it with the above formula However, it's not working if 1 or the other is opposite of = Will not work with both criteria I need it to show if either one of...

Using Crystal 2008 - NEWBIE Have cascading table pulling data from field 1 in table is clientname field 2 client type field 3 start date field 4 end date field 5 yes/no {@maxdays} \\ which is (DateDiff ("d",{fc_invoice.fc_start_date} , maximum ({fc_invoice.fc_end_date}))) +1\ need the...