Im meant to calculate the total number of viewings in a table and if the Id in the table matches the one in a form . The total number if viewings should show in the form
Novice
Windows XP 
Access 2007
Im meant to calculate the total number of viewings in a table and if the Id in the table matches the one in a form . The total number if viewings should show in the form
Access Developer
Windows XP Access 2003
Perhaps you could create a text box control in the forms Footer section and use DCount() function as its Control Source property.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Posting Permissions
Reply With Quote