|
O.P. MS Access - How to make a query showing filtered results
The title isn't that descriptive but I dunno how to describe in short what I need:
Ok, so it has been years since I touched MS Access.
I have a table (Table1) with some columns.
The first column consist of a unique autonumbering long integer (the index)
The last column is the problem here. And what my question is about.
This last column should contain a long integer which points back to some record in that very same table. No problem here, but:
How do you make a selection query to put in that last column which shows you the list of records in that very same table but without the current record (thus where the ID of the current record (the one which initiated the query) is not the same as the ID of the records pulled from the very same table).
Example:
#ID Name Infant of
1234 Cookie 4567
3456 Dada
6789 BoBo 1234
I know you can make joins which point back to the same table by adding that table twice in the relationship window. But what do you need to enter in the criteria field for that last column in the selection query.... "<>[Table1].[ID]" does not work
I have no clue...
(If the above isn't clear enough, I could attach an example db with what I have atm)
This post was edited on 05-11-2008 at 12:30 PM by CookieRevised.
.-= A 'frrrrrrrituurrr' for Wacky =-. | 
/ 
