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 3 1552
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 "tblSchedul e"
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.Nam e,
tblSchedule.Bui lding
FROM
tblSchedule
WHERE
tblSchedule.Wee kDay = [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.Emp loyeeName,
tblBuilding.Bui ldingName
FROM
(tblSchedule
INNER JOIN tblEmployee
on tblSchedule.Emp loyeeID = tblEmployee.Emp loyeeID)
INNER JOIN tblBuilding
on tblSchedule.Bui ldingID = tblBuilding.Bui ldingID
WHERE
tblSchedule.Wee kDay = [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?
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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Simon Harvey |
last post by:
Hi everyone,
I need to make a service that monitors a directory for changes in the files
contained within it. I have two questions:
1. I'm going to be using a FileSystemWatcher object to do the monitoring -
but do I need to somehow involve another thread to allow the service to do
other stuff as well, or is another thread created automatically when the
FileSystemMonitor object is created?
|
by: Mike D |
last post by:
I have a stored procedure that I am executing with this SQL
osp_instrument_swap @InstrumentFrom = 'testname', @InstrumentIDTo = 37,
@Schedules = '593, 594, 596, 598, 599, 600, 601, 602, 603, 604, 605, 606,
607, 608, 609, 610, 611, 612, 613, 616'
the @Schedules are ID fields in a table that are integers. I would like to
do an Update blah, Where ScheduleID in (@Schedules) instead of looping. How
can I do this? I have to sent the values...
|
by: stephane |
last post by:
I am preparing an exam and I have a copy of last year exam.
I answered the first questions and I wander if I am right or wrong. Can
someone have a look at the questions and at my answers please?
There is no code to write just general questions about the two class'.
the code:
/--
|
by: angelasg |
last post by:
I am working with employee schedules. Each schedule is comprised of
segments (shift, lunch, break, training, etc.) that have rankings.
Each record has the employee id, the date the shift starts, the start
and end time of each segment, the duration,the segment type and its
rank. The start and end times of the schedules can overlap, but the
segment that has the higher rank takes precedence.
As a simple example, an employee working 8a-5p...
|
by: Colm O'Hagan |
last post by:
Hi there,
I wonder if anyone out there can help me.
I'm setting up a database at the moment for a manufacturing company.
In my database I have a table listing all the company products; I have
a related table listing the subcomponents of each product. (The
company makes both the sub components and finished products.) I have a
third table called production list.
| |
by: dhnriverside |
last post by:
Hi peeps
Ok, so I thought I'd have a go at making a console app in VS2k5... I haven't
written any windows apps for years, let alone dos apps (been web programming)
and I've hit a dumb error...
"An object reference is required for the nonstatic field, method or property
"
This is occuring in my main function...
|
by: Jason Gillikin |
last post by:
Here's the scenario. I'm building an integrated electronic health
record for maternal/infant outpatient case management for my employer,
a hospital. We are basing the EHR in Access 2003 (fully expecting to
move to SQL server after we go live and add users).
One core piece of the database involves the users' need to manage
schedules from within the EHR. I need an ability to push appointments
from Access to Outlook 2003/Exchange, and to...
|
by: maverickman4 |
last post by:
background/setup info:
so we have a network set up of about 23 computers including our server which is running windows 2003 standard. we have an incredible amount of traffic going to that server due to every workstation viewing and writing data every few seconds. this is an orthodontic office that is completely paperless. charts and personal info are all on one SQL database on one server. i have pictures to manage and everything. but between...
|
by: bhipwell via AccessMonster.com |
last post by:
Hello,
I have developed an employee benefits database that currently contains over
3000 employees and 70+ companies. Having started the database as a really
simple solution for our clients, the last six months have demanded more
complexity and thus much of the recent work has been patch work to say the
least. I finally hit the "too many fields defined error" and now is the time
to go back and rebuild part of the database resulting from...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |