OK, I'm designing a form that will allow me to select one or more fields from a table, and then print a report depending on the value of the selected field(s) sorted by date.
For example, say I have a table with the fields:
Name | Cat | Dog | Age
Cat and Dog are yes/no fields.
So on my form let's say I select Cat.
On the report I want all the records with a Cat value of yes, sorted by their age.
Doesn't seem like it should be that difficult but I've been playing around with it for awhile and don't seem to be getting anywhere.
Thanks.
For example, say I have a table with the fields:
Name | Cat | Dog | Age
Cat and Dog are yes/no fields.
So on my form let's say I select Cat.
On the report I want all the records with a Cat value of yes, sorted by their age.
Doesn't seem like it should be that difficult but I've been playing around with it for awhile and don't seem to be getting anywhere.
Thanks.