I just created a query with Query Generator that compares purchase details between two date ranges. The dates are provided by the user. On the condition clause, I put T0.Docdate>=[%0] and T0.Docdate<=[%1] for the first range and T0.Docdate>=[%1] and T0.Docdate<=[%1] for the next range. Docdate is the field Posting date and thus on my selction criteria, all the field names appear as Posting Date. I want to change these to be more descriptive like Posting Date 1, 2, 3, 4 or such other description.
How do I do this?