List Box

[Dan @BCBS]

My query runs based on Data Data entered on a form:
WHERE (((tblQualityData.IssueCloseDate) Between
[forms]![frmReportsQuality].[txtstart] And
[forms]![frmReportsQuality].[txtend])

When I add:
WHERE (((tblQualityData.GBULocation)=[Forms]![frmReportsQuality]![lstArea])
AND ((tblQualityData.IssueCloseDate) Between
[forms]![frmReportsQuality].[txtstart] And
[forms]![frmReportsQuality].[txtend]

Why can I not add the value of a list box to this query????

 

[KARL DEWEY]

Test what the listbox is providing to the query by adding
[Forms]![frmReportsQuality]![lstArea]
in the SELECT statement without it being in criteria.

 

[Dan @BCBS]

I added , [Forms]![frmReportsQuality]![lstArea] AS Expr1 - to my Selection.
I get the same amount of cases returned with or without it.
Then if I select one on the form, it still does not change the amount of
cases returned.

Test what the listbox is providing to the query by adding
[Forms]![frmReportsQuality]![lstArea]
in the SELECT statement without it being in criteria.

My query runs based on Data Data entered on a form:
WHERE (((tblQualityData.IssueCloseDate) Between
[forms]![frmReportsQuality].[txtstart] And
[forms]![frmReportsQuality].[txtend])

When I add:
WHERE (((tblQualityData.GBULocation)=[Forms]![frmReportsQuality]![lstArea])
AND ((tblQualityData.IssueCloseDate) Between
[forms]![frmReportsQuality].[txtstart] And
[forms]![frmReportsQuality].[txtend]

Why can I not add the value of a list box to this query????

 

[KARL DEWEY]

I guess I did not make myself clear. I mean for you to compare the results
of the Expr1 field with data from your GBULocation field.

If one is a number and the other text then that is the problem.

I added , [Forms]![frmReportsQuality]![lstArea] AS Expr1 - to my Selection.
I get the same amount of cases returned with or without it.
Then if I select one on the form, it still does not change the amount of
cases returned.

Test what the listbox is providing to the query by adding
[Forms]![frmReportsQuality]![lstArea]
in the SELECT statement without it being in criteria.

My query runs based on Data Data entered on a form:
WHERE (((tblQualityData.IssueCloseDate) Between
[forms]![frmReportsQuality].[txtstart] And
[forms]![frmReportsQuality].[txtend])

When I add:
WHERE (((tblQualityData.GBULocation)=[Forms]![frmReportsQuality]![lstArea])
AND ((tblQualityData.IssueCloseDate) Between
[forms]![frmReportsQuality].[txtstart] And
[forms]![frmReportsQuality].[txtend]

Why can I not add the value of a list box to this query????

 

[KARL DEWEY]

For example maybe the listbox has Alabama or Arizona and the field has AL or
AZ.

I guess I did not make myself clear. I mean for you to compare the results
of the Expr1 field with data from your GBULocation field.

If one is a number and the other text then that is the problem.

I added , [Forms]![frmReportsQuality]![lstArea] AS Expr1 - to my Selection.
I get the same amount of cases returned with or without it.
Then if I select one on the form, it still does not change the amount of
cases returned.

Test what the listbox is providing to the query by adding
[Forms]![frmReportsQuality]![lstArea]
in the SELECT statement without it being in criteria.

:

My query runs based on Data Data entered on a form:
WHERE (((tblQualityData.IssueCloseDate) Between
[forms]![frmReportsQuality].[txtstart] And
[forms]![frmReportsQuality].[txtend])

When I add:
WHERE (((tblQualityData.GBULocation)=[Forms]![frmReportsQuality]![lstArea])
AND ((tblQualityData.IssueCloseDate) Between
[forms]![frmReportsQuality].[txtstart] And
[forms]![frmReportsQuality].[txtend]

Why can I not add the value of a list box to this query????