Hi. I hope someone can help.
I have a main form that has a list of occupancies. In and Out. I'm trying to get a counter alert on the main form to display Maximun if the manually set maximum is reached based on the total of entries minus outs in one day. I'm not sure where to do this, on the form or in a query.
I've attached a sample db.
Thank you ahead of time.
I have a main form that has a list of occupancies. In and Out. I'm trying to get a counter alert on the main form to display Maximun if the manually set maximum is reached based on the total of entries minus outs in one day. I'm not sure where to do this, on the form or in a query.
I've attached a sample db.
Thank you ahead of time.