Creating an "expired" group in a report

[TaylorH24]

I'm having some trouble with creating groups for my report. I'm unsure whether it can actually be done so I thought I'd ask here.

What I have are a load of records with due dates assigned to each one and I've made a report with shows expired records and records expiring in the next 30 days.

I'd like to create two groups in this report, one group showing records that have already expired and another showing the ones that are expiring in the next 30 days.



Can this be done?

Thanks for any help in advance.

[ranman256]

Yes, make a field in the query,
IIF(DateAdd("d",30,[myDate])>=[ExpDate],"About to Expire",IIF([myDate])>=[ExpDate],"Expired","Good")

[TaylorH24]

Sorry, do you mind explaining further? I should have mentioned I'm relatively new to using access and haven't done much work with queries, not enough to know where to put that expression anyway.

Thanks for the help.

[ranman256]

In the query, there are many empty columns in the grid.
pick an empty column, type in the code given.