Recent content by Archie999

It works Thanks Wayne, that did it. Totally forgot about those pesky date identifier thingies. Arch

Hi again ... Thanks for your response. I have implemented what you have suggested and am stumped as to why it is not giving me the expected results. Here is my query now: Select * from tblIssueIncident LEFT OUTER JOIN tblIssueUpdate ON...

Hi Wayne, You are right that I do not want to retreive ONLY the ones closed, with an IssueClosedDate within the last week. I want to retreive as follows: A) SiteID = 87 B) StatusID IN (1,3,99) C) StatusID = 2 D) IssueClosed Date within the last week Retrieve IF (A and B) Or (A and C and D)...

Hi, I have the following query that I cannot get to work. Select * from tblIssueIncident LEFT OUTER JOIN tblIssueUpdate ON tblIssueIncident.MyIssueIncidentID=tblIssueUpdate.IssueIncidentID where [tblIssueIncident.SiteID]= 87 AND [tblIssueIncident.StatusID] IN(1 , 2, 99) AND...

Thanks Jon, What you say makes sense, if that was the entire query. The confusion would come when other part of the query potentially conflict with this part of the where clause. For example, in the dynamic query search form the user can select status(es) from a list box. (This is an Issue...

Hi All, I have a dynamic query (below). I would like to add one more criteria to the where clause... but it is a combination of 2 different criteria in one and I'm drawing a blank as to how to do it. How can I add the 2 criteria so that they are not taken individually I want: If StatusID = 2...

Hi All, I have read quite a few threads here as well as some of the online help in Access but I'm still a little confused about grouping and sorting via VBA. I have so far been unsuccessful at making this work on my DB. The part that is particularily confusing is the difference between setting...

I am experiencing problems with the dynamic query and am hoping I can get another set of eyes on this. Or perhaps this is a limitation of Access in which case I could use some fresh ideas. With much help from this forum I have a set of 3 related queries that give me the data I need to fill some...

Thank you so much Jon. You the man! That worked beautifully. I was on the right track but I can see the error of my ways. I'm not quite there though :-) To complicate things I need to Join your Query3 to a dynamic query to acheive my goal. When I try to do that it asks me for...

Yup, that's exactly what I'm saying. It still does not work. Thanks

Hi All, I have an issue that's driving me crazy because logically, to me anyway, this should work... Access 2002 doesn't see it that way :-( My goal is this: I have a parent table (IssueIncident) and a child table (IssueUpdate). I am making a summary type report that should display all issues...

Yes, the code is in the form's error event. That part is definetly working because when I put a MsgBox(err.Number) before the IF statement, that part runs and returns a value of 0 in the Message Box. So, when I think of it, the code is likely fine (albiet obsolete in parts). The question is why...

Hi All, For some reason the following code is not trapped when I get the error message (3201) 'The field 'whatever' cannot contain a Null vaue because the Required property for this field is set to True. Enter a value in this field.' This is my code and it actually works fine in a different...

Got This To Work Hi Again, I spend more time on this and finally found something that works. Thanks anyways... It was complicated to explain. FYI for any future readers that have a similar issue. What I did was to modify my SummaryQuery (which previously simply retreived the latest update)...

Hi All, With help from this site and the Microsoft site I have created a dynamic query that I use as a recordset for a report. However, there is one thing that I have been unsuccessful in doing thus far and would appreciate an expert's opinion :-) To summarize by DB, here are the applicable...