By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,340 Members | 1,673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,340 IT Pros & Developers. It's quick & easy.

Help with microsoft access for making schedules

P: n/a
Here is the scenario. I have a list of people, what building they work
in, and on what days.

Is there a way in access to pull up this database and have it make a
list based only on the days, like select monday and everyone who works
on monday will be listed along with the building they work at on a
sheet to print out?

im a newbie to access but know a veteran amount about other office
products. any help at all would be greatly appreciated.

thanks in advance,

Ken Lafayette, Jr
Assistant Liaison
KAS Transportation

Dec 11 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
It's hard to know how to advise you as you do not give much information
on the database you are working on. did you build it yourself? How
comfortable are you going into the database and looking at tables and
queries?

I'm guessing that all this information is all in the one table? Let's
call it "tblSchedule"

There are a number of ways of producing this information. Probably the
best way for you to do this would be to use a parametarised query:

SELECT
tblSchedule.Name,
tblSchedule.Building
FROM
tblSchedule
WHERE
tblSchedule.WeekDay = [Please enter a day];

Create a query from scratch (without the wizard) and go into the "SQL
view". Copy the above text in and adjust it so that the table name and
field names match whats in your database. When you open this query you
will be prompted for a day. Enter it, and all the matching records will
be displayed.

However, if the employee and building records are other tables, as they
should be in a well designed table schema, your query may look more
like this:

SELECT
tblEmployee.EmployeeName,
tblBuilding.BuildingName
FROM
(tblSchedule
INNER JOIN tblEmployee
on tblSchedule.EmployeeID = tblEmployee.EmployeeID)
INNER JOIN tblBuilding
on tblSchedule.BuildingID = tblBuilding.BuildingID
WHERE
tblSchedule.WeekDay = [Please enter a day];

So you see, it's quite hard to tell without knowing more about your
data structure. Can you tell us more?

Dec 12 '05 #2

P: n/a
i havent even created a database yet, so i can create it however is the
easiest way.

what data i have is just in a paper sheet now.

the data i have is:

a column of names, a column of buildings, and what days each person
works.

im not familiar with access that much, but i know a few things that are
very rookie.

Dec 12 '05 #3

P: n/a
I recommend you do some reading on database normalisation and
referential integrity before you start. Your table design and
relationships are your foundations and will shape how the entire
database operates (or doesnt!)

You are in a rare position to create an ap from scratch and if you do
your research now you will save yourself a LOT of heartache in the long
run. If you understand those two topics then you are in a great
position to create a database which will will not only be more
efficient and easier to use, but you will be able to expand it far
easier to grow to your needs

Dec 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.