Greetings,
I have a Form in my Access database that is based on a query.
My form consists of multiple textbox controls and the goal is to allow the user to enter either the date range start and end values, and/or Fund Year and/or Fund Name Listing.
My query selects records from my table with the following criteria for the controls listed on my form. When the user clicks the Search button it opens a form whose record source is based on the query.
My query works if I enter values for the Date Processed fields or values for everything, however, if I enter just the Fund Year and/or Fund Name Listing it's not running. I modified my query and removed the criteria for the Date Processed field and it worked for the Fund year and Fund Name Listing. When I return the criteria for the Date Processed field it's does not work.
What does Access see when nothing is entered in a date field? I need to use Between/And because I want to search within the range of date values entered. Any ideas on how I can get this to work? I am dumbfounded by this. Obviously, the value of null or maybe zeros (if nothing entered for the date) is being interpreted as criteria when the query runs. So it's looking for blanks or zeros.
I am so frustrated with this and appreciate any assistance.
Thank you for your time and help,
Ann Marie
I have a Form in my Access database that is based on a query.
My form consists of multiple textbox controls and the goal is to allow the user to enter either the date range start and end values, and/or Fund Year and/or Fund Name Listing.
My query selects records from my table with the following criteria for the controls listed on my form. When the user clicks the Search button it opens a form whose record source is based on the query.
My query works if I enter values for the Date Processed fields or values for everything, however, if I enter just the Fund Year and/or Fund Name Listing it's not running. I modified my query and removed the criteria for the Date Processed field and it worked for the Fund year and Fund Name Listing. When I return the criteria for the Date Processed field it's does not work.
What does Access see when nothing is entered in a date field? I need to use Between/And because I want to search within the range of date values entered. Any ideas on how I can get this to work? I am dumbfounded by this. Obviously, the value of null or maybe zeros (if nothing entered for the date) is being interpreted as criteria when the query runs. So it's looking for blanks or zeros.
I am so frustrated with this and appreciate any assistance.
Thank you for your time and help,
Ann Marie