I have a table that has three columns, Beg_Date, End_Date, and Rpt_Month. I then have another table that has a Cal_Date. I want to create a field in the new table that if the Cal_Date is Between the Beg_Date and End_Date that it put out Rpt_Month.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
IF Date Between two Fields
- Thread starter noletwin1
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,474
- Office Version
- 365
- Platform
- Windows
You didn't mention that this was an Append Query. You seem to have a lot going on there, and it is difficult to decipher it all without having a full understanding of your data, table structure, and goals.
But I do think I see an issue. You have [StartDate] and [EndDate] in the HAVING clause of your query. You cannot put fields that are not part of what is being returned in your query in your HAVING clause. You can do that sort of thing with WHERE clauses, but not HAVING clauses, since HAVING clauses are applied to the data set AFTER it is generated (and not BEFORE like WHERE clauses are).
But I do think I see an issue. You have [StartDate] and [EndDate] in the HAVING clause of your query. You cannot put fields that are not part of what is being returned in your query in your HAVING clause. You can do that sort of thing with WHERE clauses, but not HAVING clauses, since HAVING clauses are applied to the data set AFTER it is generated (and not BEFORE like WHERE clauses are).
Upvote
0
Excel Facts
Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Similar threads
- Solved
