V
Vsn
Hello all,
Can somebody tell me if and how it is possible to change the domain from an
aggregate function for an SQL string?
I think about something as below but cant get it to work:-
MySql = " " _
& "SELECT tblNumbers.fID, tblNumbers.fNum " _
& "FROM tblNumbers " _
& "ORDER BY tblNumbers.fNum " _
& "WITH OWNERACCESS OPTION;"
DCount ("fID",MySql,"fNum>100")
Thx for any suggestions,
Ludovic
--
Can somebody tell me if and how it is possible to change the domain from an
aggregate function for an SQL string?
I think about something as below but cant get it to work:-
MySql = " " _
& "SELECT tblNumbers.fID, tblNumbers.fNum " _
& "FROM tblNumbers " _
& "ORDER BY tblNumbers.fNum " _
& "WITH OWNERACCESS OPTION;"
DCount ("fID",MySql,"fNum>100")
Thx for any suggestions,
Ludovic
--