I'll have to try accessing that from home, but when I tried the link from my smartphone, the file only showed a text file. I'll check when I get home but are you sure that the file uploaded?
I'll have to try accessing that from home, but when I tried the link from my smartphone, the file only showed a text file. I'll check when I get home but are you sure that the file uploaded?
Yeah, it's up on the web courtesy of Google Docs.
Thanks Bob.
PS: You have to click the download file button in the right hand corner
Here you go (and you could have uploaded it here if you ran Compact and Repair and then zipped the file).
Thanks Bob. That looks pretty good but is there a way to get a total count under every week heading or next to every week heading of how many jobs I applied to in that week?
Thanks
Change the grouping and sorting properties of the date grouping (which is grouped by Week by the way) to include a group FOOTER. Then you can use =Count([FieldNameHere]) to get the count by week. Just make sure that you rename the control which is bound to the field you are wanting to use in that formula to something other than the field name because otherwise you will get a #Name error. You use the field name in the count formula but there can't be a control with that same name on the report. So if you had a field named Applied (which I think you do as a checkbox) you would change the checkbox name to chkApplied and then in the formula you would use =Count(chkApplied).
Thanks Bob and Alan. I'll finish this later because I'm leaving for a vacation today but I'll mark it as solved b/c we're pretty close I think.
Thanks again for all your help, both of you.