Recent content by proflola

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...

Duane, Thanks for your quick reply! I'm teaching myself SQL, but I'm still limited with what I can do with it. Your SQL query should really help. I also developed a form that allows the user to input a WeekEnding date which is used to calculate the previous 3 previous weekdays by subtracting...

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...

Thank you, PHV! It got me past my "Access query" block. :)

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...

Hooray! It finally worked. I forgot about that I had a start date and end date that was affecting the data, too. Boy, I must be out of it today! Thanks again! Sandy

Hi Traingamer, Thanks for your fast reply. I was sure it would work, but unfortunately it didn't. Here's the query criteria I used: Like [Forms]![CaseFrm]![txtSection] In the Control [TxtSection] on the form, I have the value * showing after I made the GotFocus--TxtSection="*". I actually...

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...

Thanks again, Skip!

Skip, Thanks for your response. At least now, I also know how to blank the cell, too. :) Sandy

NEVERMIND....I figured it out myself... =IF(ISBLANK(B6),0,(C5-B6)) ----Sandy

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)...