Search results for query: *

I have a report that is summarizing employee hours. It groups by Firm, Employee, Funding code and Practice Group. One of the funding codes is call Leave and the group specifies that Leave be listed first. I now need to split two employees Leave hours by 70/30. There is a running total called...

All of my selection criteria is from the cases table, which is the main table. The problem table is just the table that translates the code for "problem" into an understandable label; it doesn't host any of the actual case data. You did give me an idea that worked though. I moved my record...

I'm using Crystal XI and I need to have all the names in a menu table display even if there is no match in another table. This is what I have: Menu_Problem table left joined to Cases table on menu_problem.value=cases.problem I'm grouping on the field menu_problem.label and have running totals...

I liked that idea and used it in my YTD report, but when I inserted it as a subreport and linked using the {?enddate} the YTD subreport only pulls records for that end date. So, I went back to the YTD report and modified the date parameter to be {cases.close_date} in Date(2007,01,01) to...

Thanks for trying. It's kind of weird that it doesn't work. Since the begin date of the subreport is 1/1/2007 and won't change until 2008 I decided to just keep the end date parameter and hard code the begin date in the subreport.

There are no links set up. This is what I have in the subreport>report>selection formula>record: {cases.office} = "Le" and {cases.close_date} in {?First Date} to {?End Date} and not ({cases.disposition_status} in ["020", "017"])

I inserted an unlinked subreport into a main report in Crystal XI. For some reason my subreport takes on the same date parameter prompts as my main report even though it is not linked. I tried changing the name of the subreport parameters so they weren't the same, but that doesn't help...

I have a query that creates a list of cases and how many days it took to close the case. I need to calculate the average number of days it took to close a case based upon the user and the problem type. Here's a sample of the data...

Thanks. It seems to work fine, but now I have another question. What would I need to use if instead of returning the actual hours worked on days that also have Leave time I wanted instead to return 7.0 minus the Leave time? After I ran your query I found that several of the staff put in 7...

I have a query that sums the daily hours for each employee based upon 2 categories (Normal and Leave). Since most of these employees are salary-exempt, I need to report 7 hours total for each date unless they took leave time, which if they did I need to report how many total hours of leave time...

I went through Insert|Chart again and it seems to be working after choosing the correct Master/Child link.

I have a query that shows: YearOpen County Countofnumber The data is sorted by year and I created a report that shows the list of counties grouped by year (one year on each page). I inserted a chart into the YearOpen footer, but I only want the chart to show one year on each page; right...

It's on a query and does not need to be updateable. If you can help, that'd be great. If not, thanks for the other help. Tina

I don't think I have the access to do that. It's not my database; I just use it. If I changed anything, the IT Manager and her supervisor would probably have kittens. :-) If you have the time, I have another issue. I work in legal services and my queries almost always include the client...

I think my query is too broad for that. The database does have an offices table, but my query is pulling anything that had to do with a tax case for the first half of the year. Then, in my report, I was summing the different activities: cases opened, closed, denied, etc. by the date criteria...

Duane, Thanks a bunch. It appears to be working; and you have given me another expression string to explore. I took a few of those adult ed Access classes, but they just don't get very deep, so I'm still more self-taught than anything. I appreciate all the help I can get.

I'm trying to count how many offices opened cases between 1/1 and 6/30. My query is set up with these fields: office, disposition_status, and open_date. In my report, for 1 organization I used: =Sum(abs([office]="As" and [disposition_status] Between "001" and "002" and [open_date] Between...

I have a query that pulls client data between a certain time period. I'm trying to total the following in a report: Ethnicity Under 18 18-59 60+ Total White African American Hispanic I'm using this as my control: =Sum(Abs([ethnicity]="W" and [client_age] >="60" or...