Solved

Creating a Calendar Report

Posted on 2004-08-14
4
226 Views
Last Modified: 2012-05-05
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
Comment
Question by:centrixdental
4 Comments
 
LVL 15

Accepted Solution

by:
will_scarlet7 earned 250 total points
ID: 11802168
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
 
LVL 34

Assisted Solution

by:flavo
flavo earned 250 total points
ID: 11802723
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

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Refreshing a form in Access when saving data? 3 41
Before insert Image (OLE) resize image 11 40
ms/access hyperlink/ftp 7 31
Access Query based on a Form Field 2 10
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now