• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

Creating a Calendar Report

Basically I am trying to create a review schedule for an art department.  I have a table with a lot of information including a "Date For Review" field.  I want to display the following fields based on a given job "Job Number", "Product", "Customer Territory", "Collateral Type", and "Publication"  in a calendar type report. I would like to be able to display multiple jobs for a given day as well as show days that have nothing due.
0
centrixdental
Asked:
centrixdental
2 Solutions
 
will_scarlet7Commented:
I was hesitant to offer any advice on this one, as I thought someone else could probably offer a suggestion that would be more "professional" as the only way I can think of to do this would be to create a list of all dates in the month that you want in your report. The most dynamic way to do this that I know of is to create a table that contains 31 records with a text field containing a number (from 1 to 31). then create a query that creates dates out of the number of the month you want to view as well as the day from the text field and the year. You can then link your table to this to get a list of all jobs for the calendar period desired.
0
 
flavoCommented:
I asked a similar Q last year to get some toher expert inout, see the sol~n here:

http://www.experts-exchange.com/Databases/MS_Access/Q_20834483.html

Dave
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now