Recent content by royalrochelle

I think I might have figured it out. I have full access to the shared server but Mary Jane does not. I tried it on another person's computer who does not have full access and she is missing the same data.

I tried to research this but with no luck. I work in an office where we use the same database in a folder on a shared server. When Mary Jane is signed on to her computer she can't see all of the data for a record but I am able to see all of the data for the same record on my computer. So I...

Thank you so much. This worked!

I work at a research center and I am trying to get the average weeks that a patient was on a study. If the patient is no longer on the study I do the following: WeeksOnStudy = (Off_Study - On_Study) / 7 but if the patient is still on the study I do the following: WeeksOnStudy = (Date -...

Thank you so much! This worked.:D

I was trying to use the Common Dialog Control in Access 2003 but I found out it is not available. During my research I found that I need to purchase Visual Basics 6.0 or Visual Studios.Net. I have no problems adding this software to my computer, the only problem I have is, the user doesn't have...

Is it possible to retrieve data from another report? If so, what is the code that will allow me to do that?

I have a report that calculates the totals and displays it in the Report Footer. I want these same totals to display in the Page Header instead. When I put the code in the Page header it will calculate the numbers page by page. Meaning, the 1st page will say the totals for that page, the 2nd...