Search results

  1. M

    Total with a group by query

    I have a query that takes in two dates, start and end, and a team as parameters. It calculates average interview times, and total interviews grouping by each person in that team. I would like to add a column at the end that shows the total number of interviews done by the entire team. Output...
  2. M

    Dcount on report

    I have a report based on a query that requests two dates as criteria, start and end. THe query pulles records from my table that fall between those two dates. In my page header I have a textbox that I would like to count the number of records pulled by the query, but I don't want all of the...
  3. M

    Query Question

    I have a query I need to design and I am having a bit of trouble figuring out how to do it, my access skills are not my best. I have a table with several fields, but only two are relevant to the query. The first is a case number, and the second is a date. Some records have the same case number...
  4. M

    Filter a subform

    Hi, I have an unbound form with a subform that is linked to a table called Master Table. The subform is just a datasheet view to look at records. I have controls on the main form that should allow the user to enter the last name of someone and when they click search the form filters the...
  5. M

    Batch reports

    I have been asked to come up with a solution for printing a batch of reports. It would work like this, there would be a table with employer names along with employee information. The process should cycle through all the employers and group all of the employees belonging to an employer on a...
Back
Top Bottom