Search results

  1. R

    IIF statement to count multiple records instances in a query

    Title may not adequately describe what I'm trying to do. I work for a school and I'm developing a way to track student tardies. I need a way to determine if a student has received multiple tardies in a single day and to count how many they got on that day. Specifically, we have a threshold of...
  2. R

    Emailing individual reports to individual users

    I'm trying to come up with a way to email pages of a report to the person the page of the report has on it. Each page of the report has data about an individual person, some people will have 2-6 pages of data, others will have only 1. Is there a way to automatically email only the pages that...
  3. R

    Columns in Details of a Report

    I'm trying to run a report that has 2 columns in the Details. This report is for a school and all the data is grouped by student id. However, some students may have up to 10 items listed in the Details, so I want to split it up so that the report will fit on one page, rather than a single...
  4. R

    3 most recent dates

    I'm trying to pull the three most recent dates for student's courses they took in a specific content area. I already have the content area covered. My data includes a date for each course in this area but each student could have taken courses on many different dates and could have taken more...
  5. R

    Deleting and Appending data in a table from a separate database

    I'm trying to delete data in a table, say Table A, Database A, from another Database, like Database B. I hope to delete the data then "append" the data once the data has been cleared. I know how to do it within a single database through the use of delete and append queries and running them...
Top Bottom