Recent content by Lamb2087

Thank you I will check this out

Is there a way to document in access how forms, querys, tables work for users. It would be nice to create a word document in access some how with explanations.

I think the term NOT IN is causing the problem I do not see why it will not work. When I run the subquery it works just fine.

Academic Year Academic Term Academic Session They are all text datatypes

When you run it do you not even get it saying: I get this when I double click on the query where it shows all the queries in the db You are about to delete ...n record(s). ? then it prompts me for year and session If not: Are you using the ! on the query design grid to run it? When I clcik...

I ran the query as you have written it below and still not working.

Some thing is making the sql just sit and not run. I used the code you sent and it is doing the same thing it did before I made a change.

Here is what I changed it to and it still does not return anything , just sits there. DELETE * FROM dbo_idfy WHERE PEOPLE_CODE_ID NOT IN( SELECT dbo_ACADEMIC.PEOPLE_CODE_ID FROM dbo_ACADEMIC INNER JOIN dbo_idfy ON dbo_ACADEMIC.PEOPLE_CODE_ID = dbo_idfy.people_code_id WHERE...

academic term is text

Yes there are primary keys in the table and I have permission to the idfy table. I have admin rights to all the tables in this db and other db's

Yes the select subquery runs and works just fine.

Can some one tell me what is wrong with this query? Acts like it will not run. DELETE * FROM dbo_idfy WHERE PEOPLE_CODE_ID NOT IN (SELECT dbo_ACADEMIC.PEOPLE_CODE_ID FROM dbo_ACADEMIC INNER JOIN dbo_idfy ON dbo_ACADEMIC.PEOPLE_CODE_ID = dbo_idfy.people_code_id WHERE...

How are the IT jobs in Denver these days? Have they picked up at all?

Hey do I put the Cint([dbo_ALUMNICLASS.CLASS_YEAR]) in the criteria for the field Class_Year in the design view for the query or does it go some where else?

You can try putting the expression: Cint([dbo_GIFTPLEDGE.GIFT_DATE]) instead of just the field that will convert the data to an integer and then you may be able to get the min or first on that data. This is not where the problem is. It is Class_Year, and I want the oldest classyear for each...