I uploaded another one. If you look at the totals in red. Those are the totals. Each time a count is done, new customers are entering. The entries is in addition to how ever many customers that are existing in the restaurant. so if the entry is 10 at 8am and 10 at 9am then there should be 20...
I don't know the syntax but I understand the logic. I'm trying to use the below.
=IIf(DLookUp("GMAXSET","GUEST_MAX_SET")<=Nz(DSum("GCOUNT","GUEST_T","GDATE=DATE() AND INOUT='IN'"),0)-Nz(DSum("GCOUNT","GUEST_T","GDATE=DATE() AND...
It works great.
Now that I look at it, one change. LOW MEDIUM AND HIGH.
I've added some calculation fields to the form. I needed to see the actual numbers.
Instead of just Maximum and Good, how can I add the MEDIUM where the Count is Less then 5 before the Max Amount?
I've made a mistake. The count is continuous.
Example, 100 IN at 9am then another 100 IN at 10am, then another 100 IN at 11am.. then 100 OUT at 12pm .... such as the sum would be 200 minus the 100 amount of outs.
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...
Your queries worked the same as arnelgp. One of the qry must be named qryLastMovements. This query I understand, you took the max. I have to study them because I don't understand the how the second qry works to display the latest check out that doesn't have a check in yet.
Thank you.
EDITED...
Your solution worked perfect. Only the records that were needed are pulled and added into a single line.
1. Can you help explain the sql statement that you used?
2. If I'm reading it right, you created the table T because you did not want to change the original records?
3. The latest check out...