Search results

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...

The data type in the table is text and there is a numeric value as the data. This is why I am trying to convert to varchar with a query that bombs out on me and I can not figure what the problem is.

I never get a time out message! It does not lock up in the select query, only when I put in the first for the total criteria.

I want the oldest Class Year for each record. SELECT dbo_PEOPLE.PEOPLE_CODE_ID, dbo_CODE_PREFIX.SHORT_DESC, dbo_PEOPLE.FIRST_NAME, dbo_PEOPLE.MIDDLE_NAME, dbo_PEOPLE.LAST_NAME, dbo_PEOPLE.SUFFIX, dbo_ALUMNICLASS.CLASS_YEAR, dbo_ALUMNICLASS.FORMAL_TITLE, dbo_GIFTPLEDGE.GIFT_BATCH...

I changed the field Class_Year to First as the Total Criteria. I left the other fields as Group By. When I run the query it will lock up and I never get to see the results.

I have an MS Access that is the front end and link it to a SQL DB through the tables. I am wanting to only show the oldest date in a class year if the same person is listed more than once. Tried Min in the Total Criteria and it did not work. I can post the sql if needed.