What is the purpose of why you need this? As stated in the last post, you can use a subsummary report grouped by the date. The report will be based on your found set. If you dont want to lose your current found set, you can always pop open a new window and do ti there.
Also, depending on what you need, you can use a calculation with GetSummary, but much like the subsummary report, it will need to be sorted by the break field.
Our phone receptionists are not comfortable using a computer for anything and often are taking a reservation with another call on hold. Seeing the total number of guests instantly on the form as soon as they enter a "reservation date" without additional steps would be best for a smoother workflow and avoiding over booking. Using a script adds extra steps and more steps yet in getting back to the previous record set with staff that has to memorize each step. The script might work OK, but I've seen a form (years ago) that does exactly what we would like. I don't know how and they are now using a MySQL online DB.
I will need to learn what "getsummary", "subsummary", and "breakfield" are before I can try to figure out how to incorporate them into a calculation. I haven't even been able to make a script or list grouped by date showing just one line for each date yet. We would print this report at least twice a day and need a couple of weeks of reservation counts by date on each printout. The reservation counts determines many decisions (crew, food orders, cooking amounts, seating options, etc.) and is used by several people that need to get reservation counts at a glance at least twice a day.
Our current paper list look like this:
etc. for around 10 dates per list
As you can tell, I have a steep learning curve to even understand your suggestions.
Thanks for the help!
Getting a report like this can be done easily if you follow what i suggest earlier.
You would create a subsummary report, grouped by the date. You dont need the body part as that would give you details as such
Just put the summary field ( which adds up your guest count ) in the subsummary part along with the date.
As for what you were talking about for your secretaries, this is something different that you had not mentioned before. Ifyou want to check how many guests there are for a particular date that they have entered, then create a new self join relationship keyed on the date field. Now create a new calculation field with formula: Sum ( SelfJoin::guest ). Put that calc on the layout.
Now whenever the user enters in a date, it will say how many total guest there are for that date since it relates to all other records with the same date via the self join.
This will give me a direction and keep me busy for a while.