Option Groups

[jamjarr]

Hello Everyone.

I have a form that gets its data from a query.

There is a field in the query called "FinalisedDate" which is a date/time field. I want a button called Current that when pressed it shows all records where the FinalisedDate field is Null which is to be the default of when the form is open.. Another button called "Aged" is pressed it only shows records that have the FinalisedDate field has a value (i.e. not null). I want another button that shows All Records (i.e Current and Aged).

I hope anyone can help. I have searched the forums but did not find a similar problem that I can copy.

Regards

 

[RuralGuy]

I think you simply need to play around in the Query Builder for a while. I'm sure you will be able to create the queries you need.