Percentage based on Count

[bryanwank]

Hey guys,

(Mods I apologize if this is the wrong section)
I'm teaching myself access because our database's were overwhelming excel. I don't know VBA so I am missing some of the functionality of excel's functions. Here is what I would like to do, please let me know if it's possible.

I have a table with the name of a report, the items on the report, and the number of items on the report. I would like to count the instances of the names of the individual reports that appear on another table and then divide that count by the number of items on the report.



Does that make sense?

Thanks in advance,
Bryan

[June7]

Possibilities:

1. Do an aggregate query on the 'other' table that counts the records grouped by report name:
SELECT ReportName, Count(*) As ReportCount GROUP BY ReportName;
Then join that query to the first table on the ReportName fields.

2. Use DCount function - this is a domain aggregate function (DSum, DCount, DAvg, etc.):
SELECT *, DCount("*","[other table]","ReportName='" & [ReportName] & "'") As ReportCount FROM [first table];