Graphing Help needed 1

[Blondie96]

I have limited experience with access, and almost none with excel. I have been assigned creating a database system to track a room usage. One major problem I am having at this time is trying to reproduce a graph that is currently being created by hand using Excel. (All of the scheduling is currently being done by hand, the database is just now being designed, so now is the time to make any necessary structure changes )

Example Room A:

John uses the room from 9-11 on the 1st, 3rd and 10th of the month.
Mary uses it from 2-3 on the 3rd, and 10-5 on the twentieth.

I need to create a report with hours vertically (in hr increments) and days horizontally.

Columns 1, 3, & 10 would be colored red, to show John's usage, in cells-hours 9 10 & 11.

column 3, cells-hours 2 & 3 would be blue to show mary's usage.

column 20, cells-hours 10-5 would be blue for mary.


The horizontal rows are determined by the number of days in the month, vertical columns by hours room is available
(ex. 8-5 but is always constant) there can be multiple colored bars in a single column. No data (numbers) are presented just the color of the bar representing the time the individual used the room.

Can this type of graph be created using ACCESS? If I must use excel, how can I execute that from within access? Is there another graphing package that would better create this diagram for me?

 

[dhookom]

You don't need a graph for this. Take a look at the calendar reports at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

With some math knowledge, you should be able to create the layouts you need.

To help with the actual scheduling, consider the Recurring demo at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

If you have questions, come on back since I created them both.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Blondie96]

Hi dhookom,

I finally got around to understanding what your report did, and I believe the way rptAppointWeekly generates the report will do what I need.

I do have some questions about modifying (really creating the report based on my criteria grouped by room, & day) I can put the 31 fields across the row that I need. I am having a few other problems that maybe you could clarify for me. Is there some way I could e-mail you directly with specifics?

Thanks

 

[shannonhm]

actually, if you could keep this thread going, i'd really appreciate it. I too am trying to modify those reports for my own database and have gotten a bit lost. I am working off of a query that gives start & end time, etc... and when i run the report, i don't get the timeline on it...it puts the date/time at the top of the page, the doctors name (ok, in my case not a doctor, but for the sake of consistency, i will refer to the fields as they are in your database), the patients name is 1/2 way down the page & it goes to a new page for each one. I was trying the weekly report. Suggestions? I am experienced in Access, but not so much in VBA and am looking to learn more...i've learned everything so far through trial & error, but i'm stuck on this one.

 

[Blondie96]

Hi shannonhm,

Actually this same problem was posted in another forum, and went (a little) further. You might check there:

http://www.tek-tips.com/viewthread.cfm?qid=1011934

 

[dhookom]

You don't have to be concerned about using the solution in your apps unless you include the code or objects in an application that you sell.

You are expected to leave comments in the code. All that is expected is some acknowledgement of where the code comes from.

If you have technical questions, ask them here or in a new thread.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]