Query by Form

[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?

 

[Mark A. Sam]

Steve,

I'm not getting the Query by Form part, or what you are filtering with that
tool, but the Values of the combo don't seem to match what should appear in
the Month Field of the query. If you are using the month function, it will
return an integer, 1,2, etc, but your combo is setting the value to a
string, 1st, 2nd, etc. I'd check to make sure that the combo value matches
the field value you are addressing.

God Bless,

Mark A. Sam

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?

 

[Guest]

OK. What the Query by Form is... It is a form that you can create that will
give a more graphical search screen, rather than the popup define boxes in a
query. When you link the data into the query from the form, you enter [Form
Name]![Form Field] or [Form Name]![Form Field] Is Null
This will either return the criteria in your form field or everything if null.

In the Combo Field, to clarify. I have two columns. The first one is 1st,
2nd, etc which is simply an identifier for the person running the particular
query. The second column utilized the criteria of "1 or 2 or 3". The second
column is what is linked to the query.

 

[Mark A. Sam]

Steve,

I apologize for not being clear. I know what Filter by Form is, I just
don't understand what you are looking for I guess. You seem to have two
filtering methods going on here.

Is the combobox for filtering?

Is it unbound or bound to a field?

Are you applying the filter by form to the combo?

Mark

OK. What the Query by Form is... It is a form that you can create that will
give a more graphical search screen, rather than the popup define boxes in a
query. When you link the data into the query from the form, you enter [Form
Name]![Form Field] or [Form Name]![Form Field] Is Null
This will either return the criteria in your form field or everything if null.

In the Combo Field, to clarify. I have two columns. The first one is 1st,
2nd, etc which is simply an identifier for the person running the particular
query. The second column utilized the criteria of "1 or 2 or 3". The second
column is what is linked to the query.

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?

 

[Guest]

The combo box is unbound. The combo simply has the filter criteria that is
being sent to the query. What I am wanting to do is be able to select from
the combo which quarter of the year they want (1st, 2nd, 3rd, 4th) and the
query would return the data for that quarter. As an example, if 1st was
selected, then it would return the records for January, February and March.

Steve,

I apologize for not being clear. I know what Filter by Form is, I just
don't understand what you are looking for I guess. You seem to have two
filtering methods going on here.

Is the combobox for filtering?

Is it unbound or bound to a field?

Are you applying the filter by form to the combo?

Mark

OK. What the Query by Form is... It is a form that you can create that will
give a more graphical search screen, rather than the popup define boxes in a
query. When you link the data into the query from the form, you enter [Form
Name]![Form Field] or [Form Name]![Form Field] Is Null
This will either return the criteria in your form field or everything if null.

In the Combo Field, to clarify. I have two columns. The first one is 1st,
2nd, etc which is simply an identifier for the person running the particular
query. The second column utilized the criteria of "1 or 2 or 3". The second
column is what is linked to the query.

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?

 

[Mark A. Sam]

Steve,

You can't to my knowledge run a Query by Filter on an unbound control, since
there is no data to reference. You said in your original post, "In the
query, I have a field that converts the date to month...". Why don't you
place a text box on your form which is bound to that control and use that
for the filter?

God Bless,

Mark

The combo box is unbound. The combo simply has the filter criteria that is
being sent to the query. What I am wanting to do is be able to select from
the combo which quarter of the year they want (1st, 2nd, 3rd, 4th) and the
query would return the data for that quarter. As an example, if 1st was
selected, then it would return the records for January, February and March.

Steve,

I apologize for not being clear. I know what Filter by Form is, I just
don't understand what you are looking for I guess. You seem to have two
filtering methods going on here.

Is the combobox for filtering?

Is it unbound or bound to a field?

Are you applying the filter by form to the combo?

Mark

OK. What the Query by Form is... It is a form that you can create

that
will

give a more graphical search screen, rather than the popup define

boxes in
a

query. When you link the data into the query from the form, you enter [Form
Name]![Form Field] or [Form Name]![Form Field] Is Null
This will either return the criteria in your form field or everything

if
null.

In the Combo Field, to clarify. I have two columns. The first one is 1st,
2nd, etc which is simply an identifier for the person running the particular
query. The second column utilized the criteria of "1 or 2 or 3". The second
column is what is linked to the query.

:

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?