Tags: 4xxxxxxjuly, 5xxxxxjuly, 6xxxxand, access, bunch, calendar, database, dates, iejuly, microsoft, monthly, mysql, oracle, records, report, row, sql

Monthly calendar report

On Database » Microsoft Access

4,193 words with 8 Comments; publish: Fri, 06 Jun 2008 13:52:00 GMT; (250171.88, « »)

Hello, right now I have a bunch of records of dates listed in one big row...ie

July 4

XXXXXX

July 5

XXXXX

July 6

XXXX

and so on..

I would like to know how to format the report into a calendar format so that

it looks like:

4 5 6 7

XXXX XXXX XXXX XXXX

any help would be appreciated

All Comments

Leave a comment...

  • 8 Comments
    • There are some sample calendar reports at

      http://www.invisibleinc.com/divFiles.cfm?divDivID=4. One of them is

      formatted as per your needs.

      Duane Hookom

      MS Access MVP

      "Sov" <Sov.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      news:24499EE8-28D4-49CF-A152-F427F4CAAE2C.ms-access.todaysummary.com.microsoft.com...

      > Hello, right now I have a bunch of records of dates listed in one big

      > row...ie

      > July 4

      > XXXXXX

      > July 5

      > XXXXX

      > July 6

      > XXXX

      > and so on..

      > I would like to know how to format the report into a calendar format so

      > that

      > it looks like:

      > 4 5 6 7

      > XXXX XXXX XXXX XXXX

      > any help would be appreciated

      >

      #1; Fri, 06 Jun 2008 13:53:00 GMT
    • I have been looking at that, I just don't get the "weekof + 1" thing.

      I have a report that has all of the records listed. Do I create another

      report with the "weekof +1" code. What do I reference that to?

      #2; Fri, 06 Jun 2008 13:54:00 GMT
    • Your main report is based on a query that has a single record for each Week.

      The field named [WeekOf] contains the value of the starting date for each

      week. All of the subreports in the main report are related to this field

      value or the [WeekOf] + "x number of days".

      Duane Hookom

      MS Access MVP

      "Sov" <Sov.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      news:4712B95A-AD68-4A34-B42A-117C901F3098.ms-access.todaysummary.com.microsoft.com...

      >I have been looking at that, I just don't get the "weekof + 1" thing.

      > I have a report that has all of the records listed. Do I create another

      > report with the "weekof +1" code. What do I reference that to?

      >

      #3; Fri, 06 Jun 2008 13:55:00 GMT
    • So I would need to create another query that sorts all the days into weeks?

      "Duane Hookom" wrote:

      > Your main report is based on a query that has a single record for each Week.

      > The field named [WeekOf] contains the value of the starting date for each

      > week. All of the subreports in the main report are related to this field

      > value or the [WeekOf] + "x number of days".

      > --

      > Duane Hookom

      > MS Access MVP

      >

      > "Sov" <Sov.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:4712B95A-AD68-4A34-B42A-117C901F3098.ms-access.todaysummary.com.microsoft.com...

      >

      >

      #4; Fri, 06 Jun 2008 13:56:00 GMT
    • The calendar report does this. Take a look at its record source.

      Duane Hookom

      MS Access MVP

      "Sov" <Sov.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      news:322A3B95-6639-441A-9151-FB414172CC0B.ms-access.todaysummary.com.microsoft.com...[vbcol=seagreen]

      > So I would need to create another query that sorts all the days into

      > weeks?

      >

      > "Duane Hookom" wrote:

      #5; Fri, 06 Jun 2008 13:57:00 GMT
    • Thanks for you help Duane...

      I just still don't get how to do this, I don't seem to be able to group

      records into weeks

      #6; Fri, 06 Jun 2008 13:58:00 GMT
    • What are you attempting to use as the record source for your report?

      Duane Hookom

      MS Access MVP

      "Sov" <Sov.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      news:8868963D-DEF4-4B93-8327-986225C1248F.ms-access.todaysummary.com.microsoft.com...

      > Thanks for you help Duane...

      > I just still don't get how to do this, I don't seem to be able to group

      > records into weeks

      #7; Fri, 06 Jun 2008 13:59:00 GMT
    • Send me an email to access_resource.ms-access.todaysummary.com.yahoo.com.

      "Sov" wrote:

      > Hello, right now I have a bunch of records of dates listed in one big row...ie

      > July 4

      > XXXXXX

      > July 5

      > XXXXX

      > July 6

      > XXXX

      > and so on..

      > I would like to know how to format the report into a calendar format so that

      > it looks like:

      > 4 5 6 7

      > XXXX XXXX XXXX XXXX

      > any help would be appreciated

      >

      #8; Fri, 06 Jun 2008 14:00:00 GMT