Search results

Thank you! Being new to this, it's a really nice resource. And you guys are great!

Thank you!!! I really appreciate it.

I've played with this a little more - here's my IIF statement now IIf([Activitydate]>#2/1/2007#,Format(DateAdd("m",11,[Activitydate),"yyyy - q",Format(DateAdd("m",12,[Activitydate]),"yyyy - q"))) but now it's saying I can't update the records due to a type conversion failure? I'm confused...

Hi Paul, thank you for your help. :) It's much appreciated. Here's the SQL from my initial update query till I realized I had to account for dates prior to 2/1/2007. When I add the IIF to it, it disappears right after I hit okay. Is there another way for me to do this. I run this query after I...

Hi, thanks! I'm trying to do this thru an update Qry but it's not letting me? can you not do an IIF in the Update to:

Can anyone please help? I have a Booking Qtr field that if the [ActivityDate] is <2/1/2007 then it should using a Calendar year otherwise it should be using : Format(DateAdd("m",11[ActivityDate]),"yyyy - q") for example ActivityDate = 1/1/2006 the field should report 2006-1 ActivityDate =...