Search results

  1. R

    Month_No between 1 and Parent?

    I have a subreport where I have a running sum calculated for ascending months of a year. I wanted to link a main report to this subreport. The main report displays only numbers per month. If I link the two date fields in main and subreport, the subreport does not display the running sum from...
  2. R

    Calculating a year to date margin in query?

    Thank you very much for your help. I was too fixed on solving the problem in a query. Rahel
  3. R

    Calculating a year to date margin in query?

    I have a report that is based on a query with two parameters: EmployeeID and Month/Year I was asked to display a Monthly Margin ((Sum Equipment$-Sum Equip Cost)/(Sum Equipment$), which is very easy. But, they also want me to display a Year to Date Margin for every month. In a report for...
  4. R

    Frecuency of group of records?

    What kind of criteria or function can I use in Access to display the frequency of records? For example, I have a column source that lists different sources such as Internet and I want to see how often the Internet was a source for one person. Any help and advice is greatly appreciated...
  5. R

    Yeartodate sum?

    Hu! I am having a hard time right now. I am trying to find a solution for an aggregate sum that sums the equipment sold from the beginning of the year to the date the sale was made. If the amount was recorded in October, the yeartodate sum should display all amounts from January to October...
  6. R

    Recordset not updateable?

    e-mail Hi Pat, Can I have your e-mail to send you the database? That would be great. Thanks. Also, I changed the underlying query of the form after the form has been created and added new fields. I thought that that is possible, but it might not be, because now I cannot enter any data...
  7. R

    Recordset not updateable?

    Yes, set to YES. Rahel
  8. R

    Recordset not updateable?

    I want to enter info in a form and the following message gets displayed: recordset not updateable? What do I have to change? Rahel
Back
Top Bottom