Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272

    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?

  2. #17
    accessmatt is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    199
    Yeah, it's up on the web courtesy of Google Docs.

    Thanks Bob.

  3. #18
    accessmatt is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    199
    PS: You have to click the download file button in the right hand corner

  4. #19
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Here you go (and you could have uploaded it here if you ran Compact and Repair and then zipped the file).

  5. #20
    accessmatt is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    199
    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

  6. #21
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    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).

  7. #22
    accessmatt is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    199
    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.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Data group by week
    By hoachen in forum Access
    Replies: 2
    Last Post: 09-09-2011, 08:37 AM
  2. Replies: 5
    Last Post: 11-29-2010, 08:16 AM
  3. Finding last week
    By jgelpi16 in forum Queries
    Replies: 5
    Last Post: 09-21-2010, 02:32 PM
  4. Group by Week in a Crosstab Query
    By NMJones in forum Access
    Replies: 1
    Last Post: 06-24-2010, 04:09 PM
  5. columns for group detail but not group header?
    By Coolpapabell in forum Reports
    Replies: 0
    Last Post: 08-21-2009, 08:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums