I am currently developing a system that allows an individual to record information on a client (first name, last name, etc.). This information is stored in a table named client.
A client can make visits to the facility. When they do, their visit is logged in the visits table, which records the date they came, and what area they occupied.
Anyway, the clients information is entered into the form, while the visit is logged within a subform. How can I create a label on the form that will count the number of visits a client has made, and then subtract that number from 30?
Any and all help is greatly appreciated. Thanks!