Search results for query: *

Thanks Ken. It worked like a charm.

I have a query that selects a record by a specific date using the expression '[Enter mishap date (MM/DD/YY format)]' in the criteria. I need a similar query that selects all records by year group. Is there a similar sort option? The date format is 'short date (MM/DD/YYYY)'.

The report is working! Paul Bricker and PDLDavis - both of the routines work, my problem in implementing your suggestions was having it in the page footer rather than the report footer section. I'll wear my dunce cap for a day or two. Thanks again.

Paul, I tried that and got the following error msg - Syntax error (comma) in query expression '[Sum(IIF([Death)=Yes,1,0))]'. The square brackets and single quotes were added by the error routine. Am I doing something wrong? I added a text box and used the recommended formula as the record...

I have attempted to implement the suggestions found in other posts and previous responses to my pleas without success. I am preparing a report from a query. The query extracts records with 'injury'and I then need to count the 'yes' responses in six fields and sum two additional fields. I have...

I appreciate both responses. I do not know how to show the results in the report. I know how to assign a source from a table or query but not how to calculate a value and then show it. Howard

I have a program that logs OSHA safety report info. I have a query that pulls all records that have an 'OSHA 300#'. I need to count the number of 'yes' records for 5 fields in this query and sum 2 other fields. This query is the source for a report that prints each selected record and then...

I have a program that logs OSHA safety report info. I have a query that pulls all records that involve an 'injury'. I need to count the number of 'yes' records for 5 other fields in this query and sum 2 other fields. I tried doing separate queries on each counted field and entering the...