Hiestermonkey
Last Activity: Jan 31 '11, 09:54 PM
Joined: Jan 31 '11
Location:
-
I appreciate the input, but you are definitely dealing with a total novice. Please bear with me.
Here is what I have in my query (this and only this), and it is asking for 2 unique Id's (as is stated in the sql language)
SELECT *
FROM [Gallatin Org/Emplid/Quals Merge]
WHERE UniqueID IN (
SELECT DISTINCT UniqueID
FROM [Gallatin Org/Emplid/Quals Merge]
WHERE Qualification...Leave a comment:
-
Thanks for the reply Rabbit. I'll give it a shot. I'm not sure I know exactly where to put that subquery though...I'll try to place it somewhere within the initial WHERE query.Leave a comment:
-
Thanks for the reply Rabbit. Where should I start with the subquery? Like I said I'm a novice, and have very little experience with SQL. Any advice is greatly appreciated.Leave a comment:
-
How to search for multiple criteria from data stored in one column?
I am a novice Access user trying to manipulate a large database (approx. 20,000 rows of data) in order to analyze possible future employment gaps. Most of the data is duplicated, (such as name, id, position) with the exception of the persons work qualifications and the status of those qualifications i.e. qualified or trainee.
The employment qualifications are in one column and the status (trainee/qualifed) are in another column. ...Last edited by Niheel; Jan 31 '11, 05:28 PM. Reason: Click on the edit but and add your Query. It will help.
No activity results to display
Leave a comment: