Sum number of records in a subreport based on criteria

[Talonjpc]

Hi Everyone:

I have looked all over this forum but can't seem to find an answer.

I have a subreport, srptDiskStorage, and I want to count the total number of drives that are of storage type 2 on the report. The would involve counting the records for each time a storage type 2 drive appears. I have a text box on the subreport that has the storage type on it. This subreport is based on a SQL query created in the report out of two tables tblComponents and tblDiskStorage. The Query is not a premade Query, and I would prefer not to create an actual query as I want to minimize size as much a possible

Thanks alot,
Vinay

 

[mikey69]

Suggest you do this by using a query. Add a dummy field with an iif function which writes 1 if the drive type is 2 and zero if it's not. Then use a totalling query and you'll get your answer.

You could do it in VBA using DAO, but the query would be easier and quicker.