Assuming your data looks like this:
ID Date Company Track
1 1/1/2006 "comp 1" Technical
2 2/1/2006 "comp 2" Sales
3 2/1/2006 "comp 3" Technical
4 2/1/2006 "comp 2" Sales
5 1/31/2006 "comp 2" Sales
Then either
a: you can use a crosstab query such as :
(My data is in a table called Table1)
TRANSFORM Count(Table1.ID) AS CountOfID
SELECT Format([Date],"yyyymm") AS [Month], Table1.Company
FROM Table1
GROUP BY Format([Date],"yyyymm"), Table1.Company
ORDER BY Format([Date],"yyyymm"), Table1.Company
PIVOT Table1.Track In ("Sales","Technical");
Which will get an output of:
Month Company Sales--- Technical
200601 comp 1 --------- 1
200601 comp 2 --1
200602 comp 2 --2
200602 comp 3 --------- 1
-- added as placeholders
Then you can create a form with 4 text boxes one for each column and it's easy to add a row total to see total tracks for a company in a month.
Or B:
You can use an ordinary select query such as :
SELECT Table1.Track, Format([Date],"yyyymm") AS [Month], Table1.Company, Count(Table1.ID) AS CountOfID
FROM Table1
GROUP BY Table1.Track, Format([Date],"yyyymm"), Table1.Company
ORDER BY Table1.Track, Format([Date],"yyyymm"), Table1.Company;
Which will get an output of :
Track Month Company CountOfID
Sales 200601 comp 2 1
Sales 200602 comp 2 2
Technical 200601 comp 1 1
Technical 200602 comp 3 1
NB you do need to ensure that you do not allow anything with a track that is not in "Technical or Sales" as they will be screened from the results of the crosstab.
hth
kevin