If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Queries from more than one table
I have two tables with information about students. One table for current
students and one for expected students. Both tables have a field called status. And for each student the status is different. I want to create one query that will give me the records from both tables for each student and their status. Ie I want to see whose status is say registered but from both tables in one query. Can anyone help me with this? |
#2
|
|||
|
|||
Queries from more than one table
Well, you would create a UNION query, but I would revise the data structure
if I were you. I would put them all in one table and then add an "active" checkbox or maybe a "current" checkbox or a "prospect" checkbox. Something to indicate if the student is active or a prospect. Your status list could be filtered to only offer choices valid based on this flag. -- Rick B "1foxi" wrote in message ... I have two tables with information about students. One table for current students and one for expected students. Both tables have a field called status. And for each student the status is different. I want to create one query that will give me the records from both tables for each student and their status. Ie I want to see whose status is say registered but from both tables in one query. Can anyone help me with this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table problem | Redwood | Database Design | 29 | April 3rd, 2006 04:58 PM |
Displaying File properties on a Access 2000 Form | Chris Fillar | General Discussion | 2 | March 16th, 2006 02:22 PM |
Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |