Proper format to the WHERE condition of OpenReport

[smuthcrmnl777]

I am having trouble typing up the proper format to a WHERE Condition for the OPENREPORT.

"[DateComplete] = >=DateAdd("d",-45,Now()) Or [DateComplete] = Is Null" and "[Group] IN (" & Mid(GetGroupString, 2) & ")"

How can I properly write this in VBA so the query can use this criteria without errors?

 

[RoyVidar]

Please don't crosspost thread702-1202703, see faq181-2886 #4 for why, though the whole faq is worth a read.

Roy-Vidar