Ok Sorry
yes basicaly i have a data base Paradox which i have connected to which
holds specific data on applicants-jobs etc
the table contains a unique value for all tables in app it is exp.
1-smith,
there is also a table which holds attribute data for the applicant so
app tbl attribute tbl (this contains app id)
app id: attri value:
1-smith pa
1-smith co-ord
i need to runa query which will run and show which apps have a
different
combination of attributes etc
:
When I look at the sample you provided I am forced to ask the
question,
"What kind of data is he trying to model?" Some questions come to mind
in
trying to figure that out. 1. What is "smith"? I'm assuming that
"smith"
is
a person but that could be wrong because "smith" can also be a job --
as
in
blacksmith. 2. What is "pa," "co-ord," and "TV"? Are these things that
"smith" owns? Things that "smith" does? Things that are important to
"smith"
as a person -- assuming that "smith" is a person. My answer to these
questions is that I don't know and, therefore, I wonder about your
data
design.
A database table should store information for a single type of entity,
ex. a
person. All the information that is unique to a single entity will
make
up a
record in a given table. However, if a person performs a job, has a
hobby,
owns some object, etc., those things are all different entities that
may
be
related to the person but they are not attributes of the person.
Therefore you need to sit down with a piece of paper and describe in
the
best way you can all the unique types of entities you need to store
information about and create tables for each of them. Then you will
need
to
find out how those various entities are connected to each other.
"smith"
has
a job. "smith" owns a car.
If you will describe more of what you are trying to model in your
data,
then
someone here should be able to help you with the details.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security:
www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Hello can anyone help
i have a table containing these columns amoungst others
Name: attributes:
smith pa
smith co-ord
smith TV
i need to create a query for example which shows a name that
contains
both
pa and co-ord but not just pa or just co-ord any ideas!
i have tried the 'And' criteria but to no avail!
