Recent content by jedder18

what I have is a report that counts a number of occurrences for an event. That number needs to be added to occurrences that happened before that event. I'm trying to get the prior wks to run correctly...given that the report has date parameters for current occur I know I'll be using the...

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

[2thumbsup]that was way too easy for you Thanks.. I've been using Crystal so long, I forget my access coding. 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

I put the brackets in right after I posted the question. Works like a charm... Thanks much. 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...

Nevermind... I figured it out. I closed the form then reopened to a new record... Jedder

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

Never mind... I still had a group in there that didn't belong. Got it working the way it's supposed to ... YAY.. 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

That still gave me the details of each service before the group 4 totals. Each service has a client attached to it with minutes I'm looking for the clients minutes for all services to be populated in 1 section... 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...

It shows both rates 2x.. I think because in the data entry the rate is being overwritten with the new rate..it doesn't get entered into a new field. Jedder