Skip to Content
0
Former Member
Jan 13, 2009 at 09:08 AM

Query- Selection Criteria

131 Views

Hi Experts,

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?

Regards,

Anne