acceptance form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form in a dbase for college to record applications. Then say a few
weeks later the students get accepted or refused. So i have a form for
acceptances and a form for refusals. In the acceptance form - which has
student details and sub form has the status given and date etc.

i want i to be based on a query that contains everyone who was accepted so
far plus all those with no status yet so that if they get accepted then i can
go to that form find their name and record their acceptance but i don't want
any of the students who have been refused. So in the status column i said
only "accepted" or is null. But the students with no status don't come up
becuase they don't have a record at all in the status given table - what
should i do?
 
I have a form in a dbase for college to record applications. Then say a few
weeks later the students get accepted or refused. So i have a form for
acceptances and a form for refusals. In the acceptance form - which has
student details and sub form has the status given and date etc.

i want i to be based on a query that contains everyone who was accepted so
far plus all those with no status yet so that if they get accepted then i can
go to that form find their name and record their acceptance but i don't want
any of the students who have been refused. So in the status column i said
only "accepted" or is null. But the students with no status don't come up
becuase they don't have a record at all in the status given table - what
should i do?
Click to expand...

Probably use a Left Outer Join on the query linking the two tables.
You talk about your forms (which are completely irrelevant, a form is
not data but rather just a tool to edit data) and don't describe your
tables, so I can't be sure; but I'm guessing that you have a Students
table related to a [Status Given] table.

Select the join line in the query design window, and choose option 2
(or 3) - "show all records in Students and matching records in..."
This will show all the Student records whether or not there is a
matching record in the other table, with NULL values for all fields in
the joined table if there is no record.

John W. Vinson[MVP]
 
Back
Top