Matt H
Matt H

Reputation: 147

Microsoft Access 2016 - Record Count

I am currently creating a task management system in Microsoft Access 2016 and was curious whether it was possible to create a report or form to show the count of records, the part I can't do is add the record count of two query's. Both query's come from one table but both have different Yes/No property's. The aim of this is to Produce a graph of the comparison between these two results from the number of records.

Query One:

Query Two:

Upvotes: 1

Views: 426

Answers (1)

Gustav
Gustav

Reputation: 55981

You can use DCount:

RecordCount = DCount("*", "[Quote Won Query]")

Upvotes: 1

Related Questions