Hey!

I'm trying to figure out a calcuation field that will do the following:

Figure out how many orders shipped out each day and then show that number.

For instance, on the 26th, it will find all jobs that shipped out on that day and then the result will be something like "5"

and then on the 27th, it will show "9"

And i am want to add this to a monthly calendar view so that on every day on the calendar it shows how many jobs shipped out that day.

Would anyone be kind enough to help me figure this out?

Thanks!

Depending on your setup you could maybe count unique job id's for every day and display it that way via Count (JobID) for example.

You could also make an autoenter number field which enters 1 every time a job is crated and then have a summary of that field for each day in your calendar...