Pull columnhistory based on date?

[mcgraw]

I'm trying to create a report in Access 2007 that will show all the comments that occured in the last 7 days. The comments field is a memo with the columnhistory method set, and what I would like is to only pull comments made in the past 7 days.

I tried doing this, but just get an error: ("#Error" shows up in the report itself)
=ColumnHistory([RecordSource],"Comments","[ID]=" & DateDiff("d",[Comments],Date())<=7)

I also tried =ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0) Where (DateDiff("d",[Comments],Date())<=7) but it yelled at me that the syntax is incorrect.

The DB I am working with is the "Issues" template for MS Access 2007. The table is called Issues, with a field called "Comments". Comments is a memo field with the append only set to yes.

I know very little VB (as you can tell) so I would appreciate any guidance.

Thanks!

 

[ComptechRx]

Any updates on this question?