DCount with Distinct or Remote DB

[dpimental]

Is there a way to do a dcount on a distinct list of values?

In other words, I have a field called filename. I want to take the distinct list of file names and count them.

Also, can dcount be used with tables in another database.

From currentdb, I want to do a dcount in database2, table1, for fielda.

David Pimental
(US, Oh)

 

[IanAble]

If you want to display this data in a Form it'd be easier to use:
SELECT currentdbTable.filename, Count(currentdbTable.filename) AS Count
FROM currentdbTable
GROUP BY currentdbTable.filename;

as the RecordSource. You could also set this as a RowSource for a ListBox, or ComboBox

If you want to the values in code, use it as Recordset Source and Loop through the records or use the Find method.

Create a linked Table based on database2 table1 and you can use the same arguments on remote data.