Access crosstab query update field value by Dcount -


2 tables in access 2013

table users, store users info

yyyymm | employee id | email | name | logincount

table log, store website login time

yyyymm | userid | logintime

i want update logincount field in table users count logintime when [employee id] = [userid] , user.[yyyymm] = log.[yyyymm]. codes can not work.

update users set users.[logincount] =  dcount("log.[logintime]","log","[userid] = user.[employee id] , [yyyymm] = user.[yyyymm]"); 

it says "...unknown..." error.


Comments

Popular posts from this blog

Command prompt result in label. Python 2.7 -

javascript - How do I use URL parameters to change link href on page? -

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -