Hello,
I would like to develop a parameter query that does the following:
Prompts for [Beginning with Fall (F) or Spring (S) Semester?] and then converts the response into 9/1 or 1/1 (September 1 or January 1, respectively)
And then prompts for [Beginning with what year (yyyy)]
And then assembles that date and produces a list of records that have that have an [EnrollmentDate] greater or equal than that date.
I need to put this on the criteria line or create a field in the query, rather than do it with SQL coding.
Could you give me some suggestions about this?
Thanks!