G
Guest
I am curious. I am using a query by form. I have a report which I need to
be able to have run by the quarter of the year (i.e. 1st - Jan, Feb, Mar; 2nd
- Apr, May, Jun; etc.)
In the form, I used a combo box with 2 columns: 1st - 1st quarter, 2nd
quarter, etc. 2nd column - 1 or 2 or 3; 4 or 5 or 6; etc.
In the query, I have a field that converts the date to month, and I have
added the criteria for the combo box for that field.
When I run the query by form, I receive no information back.
Any suggestions on have I can configure the criteria in the combo box to
pull month 1, 2 or 3 if 1st Quarter is chosen or whichever quarter is chosen?
be able to have run by the quarter of the year (i.e. 1st - Jan, Feb, Mar; 2nd
- Apr, May, Jun; etc.)
In the form, I used a combo box with 2 columns: 1st - 1st quarter, 2nd
quarter, etc. 2nd column - 1 or 2 or 3; 4 or 5 or 6; etc.
In the query, I have a field that converts the date to month, and I have
added the criteria for the combo box for that field.
When I run the query by form, I receive no information back.
Any suggestions on have I can configure the criteria in the combo box to
pull month 1, 2 or 3 if 1st Quarter is chosen or whichever quarter is chosen?