Hi everybody...
I'm trying to use a DCount expression. It's possible to get distinct values using a DCount in a form as Control Source, or using VBA?
I figure out a way to get distinct values by using SQL statement (in a query), like:
but I can't write more than one statement in one query.
Anyone can help me?
I'm trying to use a DCount expression. It's possible to get distinct values using a DCount in a form as Control Source, or using VBA?
I figure out a way to get distinct values by using SQL statement (in a query), like:
Code:
SELECT Count(*) AS [BookCount]
FROM (SELECT DISTINCT BookId FROM BorrowList);
but I can't write more than one statement in one query.
Anyone can help me?