New to access - help needed.

[boxman2052]

Hi,



I am brand new to using access only this week and I've been teaching myself. I have stumbled across some problems in a database I am trying to build.

The database is for the purpose of summarizing the total number of days staff have been sick over a variable period, and displaying that information as a bar chart.

So I created a form for entering staff details, and a second form for entering the date and staff name for a sick day. These both work find and it creates a list showing the date followed by the name of the person sick that day.

I'm having trouble after this. I cannot figure out how to set up a system where you can select 2 dates, and it shows a list of each staff member once, followed by the total number of days they've taken off, just like this:

John Smith 3
John Doe 4
Susan Smith 1

Etc.


I can't figure out how to either: select a date range or sum the total days they've been off, as currently it just displays as a list showing the date, then their name.

After I can get this list created, I can make a chart from it.

Does anyone know how I can proceed?

Thanks,

James.

[orange]

Since you are a self-confessed newbie who is teaching himself, I'm going to suggest a couple of articles and tutorials.
These are the ones you should start with, but you don't realize that until after you have experienced some design issues that make life very difficult.

Principles of relational Design http://forums.aspfree.com/attachment...2&d=1201055452
Entity Relationship Diagramming http://www.rogersaccesslibrary.com/T...lationship.zip

And you may find these of interest:

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

https://www.youtube.com/watch?v=lXAG...6FE5448948D9B4 E-R Diagramming Price and Quantity

Complete set of tutorials on Acc2010.
https://www.youtube.com/playlist?lis...FoilxbUY0yUqZP

[Jen0dorf]

Hi

Always ready to learn so looked at the reply with interest
the last link is invalid

https://www.youtube.com/playlist?lis...FoilxbUY0yUqZP

Can you post the correct one

thanks

Ian

[ssanfu]

And there are 2 tutorials at Rogers's Access Library http://www.rogersaccesslibrary.com/forum/forum46.html

Plus there are a lot of example dBs there also - good reference site....

[orange]

https://www.youtube.com/watch?v=hMzf6u8hWqk
This link is for a 13 video tutorial ser from Richard Rost

There is also an excellent series here from Steve Bishop.