Once a week, I would like to see a report or page showing the enquiries for that week
If it's only one week, you can simply find the records that fall in that week.
Is there a way of keeping a "live tally" of the weeks records using some kind of count calculation?
Ive generated a very simple dashboard which takes the user into Sales or Enquiries.
I wouldnt mind having the weeks enquiries count on the dashboard or within the enquiries section.
It would be a simple record count for Total Records from a Saturday to current day, then resetting every Saturday.
Do you mean "weeks" in plural? If so, how many?
Also, which version are you using?
No, sorry, a Week's singular.
FMP11 on WinXP
To summarise : We take phonecall enquiries, which need logging. And a report needs to be made, along with a "running total" of the current working weeks calls into the company.
Our working week starts on a Saturday at 00:00 and ends on a Friday evening at 23:59.
I already have reports setup for type of call etc, but I need to summarise it and count it by this weekly timeframe.
So for instance today is Tuesday, we have taken 300 calls since Saturday. I would like to see that figure somewhere on the dashboard or a report. I then need that number to reset to zero on Saturday.
Im sure this is quite simple, but Im struggling to get my head around it.:smileywink:
any help most welcome.
Well, as I said, for a report you just need to find the records of the current week and place a summary field in the grand summary part.
For the dashboard, add a calculation field to the Calls table (result is Date) =
CallDate - Mod ( CallDate + 1 ; 7 )
Add an unstored calculation field to the dashboard table (result is Date) =
Get (CurrentDate) - Mod ( Get (CurrentDate) + 1 ; 7 )
and define a relationship matching the two calculation fields.