I have an application that runs a query "Q01" and a list form that presents the query results and so, its control field is linked to "Q01". The query results in a series of fields "F01", "F02, "F03", etc. (the list of fiels is always the same)
However, depending on conditions, I need to present "Q01" both filtered by specific field values, e.g. F01 > 1234 or, mostly for dates, "F03 > Date1 and F03 < Date2" and sorted either ascendetly or descendently by another field, e.g. F07.
I need to do this programmatically in VBA
how do I do it?