Find Number of Records for each office

[Guest]

Hi, we have a major Lotus Notes database that I've pulled data from and we
want to display the total number of file reviews for each office that does
not have an engineer assigned by the project open date. We have the field for
office, another field for affected files, a project open date field, and an
engineer field. How do I write the query to just return a report showing
each office and the total number of files that have not been unassigned to an
engineer by the project open date? Thanks!

 

[Jeff Boyce]

Jan

Open a new query in design mode and select the table.

Select the four fields. Put criteria in for the selections you want (e.g.,
no engineer). When you are getting all the rows you need, you can press the
Totals button (looks like a Greek sigma) to convert the query to a Totals
query. Use "GroupBy" for the office field, use "Where" for the date and
engineer fields, and "Count" for the affected files field.

Note: I can't see your data, so I can't be sure, but I suspect you could
have a problem. If you want to know the "file" that "does not have an
engineer assigned by the project open date", it seems to me that you need
additional data, including at least a "date the engineer was assigned".
Without this, you can't tell if an engineer was assigned before the project
open date.