Separating Desired Records

K

KellyH

I work in a Univ setting. I have built a database consisting of two tables.
One contains demographic data, the other contains academic data. The tables
are linked by Student ID. We only accept certain students. What I need to
do is separate those who are accepted from those who are not. I have several
queries set up based on the status of their admission. If they are not
accepted, they will have either NQ, WD or NS. How can I pull from both
tables and make one new table based on the above criteria and then delete
those not accepted from the original two tables? I'm not sure if this can be
done or not. Hopefully this isn't too confusing. I'm just trying to do what
my boss is asking. Thanks in advance.
 
T

TedMi

Please provide more information. What fields are in the two tables? Which are
the Primary Keys? Can a student have multiple demographic records? Multiple
academic records? Where is the application status recorded?
 
K

KARL DEWEY

Many ways but one way is to create a make-table query pulling data from the
first table with criteria like --
<>"NQ" And <>"WD" And <>"NS"

Then using the same criteria make an append query to the table you just made
and pulling data from the second table.
 
P

Phillip Windell

You just use a query. Your result is,...a query "view",...not a Table.
There is no need to create a Table. It can be done with or without a
"Relationship" between the source Tables. Tables are only used to store
"original" data,...not calculated or "conditional" data.

For "calculated" Data you simply recalculate each time using the query.
For "conditional" Data you simply re-test the condition each time it is
needed using the query.
This way, if the "condition" changes, or if the source of the calulations
change,....the result is always accuarte and up-to-date.

For example, one field for "Garage Bays" and one field for "Num of
Cars",...but I am looking for "Garage Sufficiency". The calculation is:

If "Garage Bays" >= "Num of Cars"
Then "Garage Sufficiency" = YES
Else "Garage Sufficiency" = NO

I do not need to create a Table containing a field "Garage Sufficiency",...I
don't need a Table at all. "Garage Sufficiency" would just be a simple Text
Box (Radio button, whatever) on a Form. The Form would simply be tied to a
query that does the "Test" (maybe the OnLoad Event) and displays the result
in the Text Box,...there is no value that is "stored" anywhere. If the
number of "Garage Bays" change or the "Num of Cars" change the value in the
Text box will automatically change each time the Form is "opened".

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
-----------------------------------------------------
Understanding the ISA 2004 Access Rule Processing
http://www.isaserver.org/articles/ISA2004_AccessRules.html

Microsoft Internet Security & Acceleration Server: Guidance
http://www.microsoft.com/isaserver/techinfo/Guidance/2004.asp
http://www.microsoft.com/isaserver/techinfo/Guidance/2000.asp

Microsoft Internet Security & Acceleration Server: Partners
http://www.microsoft.com/isaserver/partners/default.asp

Deployment Guidelines for ISA Server 2004 Enterprise Edition
http://www.microsoft.com/technet/prodtechnol/isa/2004/deploy/dgisaserver.mspx
 
Top