Search results for query: *

Hi All you Smart Folks! I have an Access 2003 database that is tracking Claims. It's based on linked tables that reside in another database. How can I automatically update the linked tables without having to manually do so in Linked Table Manager? Thanks for any assistance you can render...

Here's the scenario: I need to count cases open at the end of each week that are <=30 days old and also the cases that are >30 days old. I've developed two queries that use a parameter to allow the user to enter the End Date. Here's a sample of one: SELECT Count(case_tracking_tab.case_no) AS...

Hello, I have a query that shows Total Closed Claims processed during a specific time period such as Between 6/1/2007 and 9/20/2007. I used the COUNT function on a Case# in a Totals query to give me the total claims processed during the time period, but I'm not sure how to do it for the...

Hi all, I'm sure this isn't too hard and if I gave myself enough time, I could figure it out....however... I have a query that displays the following fields: Case# rcvd_dt cmp_dt I need to do a TOTALS query that will count the total cases Then I need to use WHERE to age the rcvd_dt 30...

Our firm has developed a web-based application for a client. I've been doing statistical reports for the client in MS Access. Now, we'd like to incorporate those reports in the application. To use the reports, a form asks for a date range is displayed and then the user selects the date range...

Hello, Here's the scenario. Our company has developed a web-based application. The user clicks on a record in a list to review the record details. We want to have a printable copy appear at the click of a button. The data underlying the printable report is stored in multiple tables within a...

I'm working on a search form that has several unbound controls that populate the criteria on a query. This query will then be the basis for a report. I some checkboxes that place data in an unbound control named "txtSection" via the On-Focus Event on a form. In the query under the specific...

Hello, I have formula that calculates on each row. I would like to copy the formula down several rows, however the last value stays in the rows that have no data to calculate. Sample: Income Expense Balance 2200 1100 1100 (formula: =a2-b2) 500 600 (formula: =c2-b2)...

One of our developers is having a problem with connecting Visual Basic 6.0 to a Crystal Report V 8.5 that's been migrated to version 10.0. The report works fine in Crystal Reports 10.0 but when he tries to connect to Visual Basic 6.0 he gets the following error message--"20525 Unable to open...

One of our developers is having a problem with connecting Visual Basic 6.0 to a Crystal Report V 8.5 that's been migrated to version 10.0. The report works fine in Crystal Reports 10.0 but when he tries to connect to Visual Basic 6.0 he gets the following error message--"20525 Unable to open...

I can do an summary averages of the duration of calls with the following formula: Local Numbervar TotalSec := Average ({@duration})*60; Local NumberVar Hours := Truncate(Truncate(TotalSec/60)/60); Local NumberVar Minutes := Remainder(Truncate(TotalSec/60),60); Totext ( Hours, '0', 0,'') + ':'+...

Hi All, I'm trying to convert a duration which is in a number format to a date format that contains the following: # Days, HH:MM Below is what I'm using now and it converts the hours and minutes, but I can't figure out how to include the days. Here are two examples of my current conversion...

The Report is suppose to show all calls closed in the current month listed by week but incorrectly includes weeks from past years instead of just 2006. The Formulas are as follows: Crystal Month Month(HFWDatetoDate({CallLog.ClosedDate})) Current Month Month(CurrentDate) Selection Formula...

Hi All, I can figure an Average Duration in the Group Heading that gives me an average in numbers for each group (ie 133.00). I need to convert the numbers to hours and minutes which I have a formula for. The problem I'm having is that if I create a formula that does the conversion, it shows...

Does anyone have a list that explains the Heat built-in Report Functions that are used with Crystal Reports? Thanks! Sandy

Here's the scenario.... Our Helpdesk needs to create reports that calculate the duration of a call in HR:MM:SS, however it can only include our working hours minus weekends. Our work day is from 7:00 Am - 5:30 PM. Rosemary from this Forum was kind enough to help me with a solution. It works...

Hi All, I have several Crystal Reports that support our Heat Help Desk. When I run the Report to Average the Duration of Calls by Type, there's one type "Internal Errors" that scews the bar chart. The Help Desk Manager would like to omit that type when running the report. I'd like to do a...

Hello All, I have an expense tracking database. It's based on a query. I have expressions within the query that calculate the sales tax, sub-total, shipping and total. The sales tax expression first checks to see if a checkbox is checked and then figures the tax. The problem is that...

Hi all, I'd like to see if I can get this working in Access... Here's the scenario--I have a client who runs a Help Desk. I've developed an Access database that links to the Help Desk data so that I can do more extensive reports for the client. I need a formula or coding that will do the...

Below is the formula I'm trying to use to calculate the difference from the Recieved Date and Time to the Closed Date and Time, however it has to be based on 10 hour days excluding weekends. I get a message saying "date-time is required" when I check the formula. Local DateTimeVar d1 :=...