Search results

Thank you both for your excellent solution ideas. Based on your suggestions, I wrote a couple of "if then" statements in the on-click event on my "Run Seach" button. My query criteria is just a simple "Between" statement now, and everything works like a charm! Also, I agree with you plog, when...

Thanks for the words of encouragement and kind welcome Uncle Gizmo! I'll do my best to help out where I can. Thanks

Thanks for the quick response plog, those date boundaries would definitely work! By defaults, do you mean for the true parts of my nested iif statements to be "Between" #1/1/1901# and end_date, and Between begin_date and #12/31/2300#? I have tried implementing your suggestion in this way, but I...

[Solved] Query by Form Criteria Issues Hi everyone, I'm relatively new to access, and a new member to this forum. I have a Query by Form for a database search. I have two date controls on the form, "begin_date" and "end_date". The goal is for the query to return the records between the two...

Hi Everyone! I'm a recent university graduate, working at a small manufacturing/prototyping company just outside of Chicago. I've somehow become the sole access guy at work, despite having only a few weeks of total experience with it. Lo and behold, I'm a complete newbie in SQL and VBA, but I...