I'm using the below statement to see if a record exists, and if it does - to mark it with an x. The first problem is that it's not marking it with an x - but Null or -1. I can work with this - all I want it to do is distinguish between the two.
The real problem is that I hardcoded this report for specific date ranges, but I want when it turns 2004 for the query to automatically change to 2004. My boyfriend, who codes in Lotus Notes, thought I could put {2/28/2003} but that went nowhere - fast. Because I have to do 12 Iif statements (one for each month) - how can I hardcode the SQL within each to only pull the date range specified for the active year???????
Feb: IIf([MinOfConst Start]<=#2/1/2003# And [MaxOfConst End]>=#2/1/2003#,"x",Null) Or IIf([MinOfConst Start]<=#2/28/2003# And [MaxOfConst End]>=#2/28/2003#,"x",Null) Or IIf([MaxofConst End]<=#2/28/2003# And [MinOfConst Start]>=#2/1/2003#,"x",Null)
The real problem is that I hardcoded this report for specific date ranges, but I want when it turns 2004 for the query to automatically change to 2004. My boyfriend, who codes in Lotus Notes, thought I could put {2/28/2003} but that went nowhere - fast. Because I have to do 12 Iif statements (one for each month) - how can I hardcode the SQL within each to only pull the date range specified for the active year???????
Feb: IIf([MinOfConst Start]<=#2/1/2003# And [MaxOfConst End]>=#2/1/2003#,"x",Null) Or IIf([MinOfConst Start]<=#2/28/2003# And [MaxOfConst End]>=#2/28/2003#,"x",Null) Or IIf([MaxofConst End]<=#2/28/2003# And [MinOfConst Start]>=#2/1/2003#,"x",Null)