Counting Total Instances of Duplicate Fields

[sguckemus]

Hi Folks,

I am fairly new to access, so unsure if this belongs under queries or reports, so mods please feel free to move if necessary.

I have a table containing records for our use of mobile computer labs. Each Records represents 1 use of the mobile computer lab (The Day it was used, what location it was used at, The Mobile Lab ID Number, What class it was used to train etc.)

I am trying to create a report that will give me (preferably in the report footer) a count of how many times more than one mobile lab was out in the field on the same date. So for example:





With the Above dataset, I'm looking for the count to return as "2", because there are 2 days on which more than one lab was depoyed in the field at the same time (1/1 and 3/14).

Any help would be greatly appreciated,
~S

[June7]

One way is to save an aggregate query:

SELECT [Date], Count(LabID) As CountLab FROM tablename GROUP BY [Date];

Then in textbox on report use DCount:

=DCount("*","Query1","CountLab>1")

Another option might be a subreport.

Any filter criteria (such as date range) applied to the report will have to be applied to the query.