Hello,
I have created a query with fund prices and fund prices variances and I am using a combo box to set up certain criteria in the query. The idea is that a user can select to see funds whose prices have varied 0%, 0.5% etc... This is my query:
SELECT FundPrices_Qry00.Date, FundPrices_Qry00.Fund_Name, FundPrices_Qry00.MCH_Code, FundPrices_Qry00.Variance
FROM FundPrices_Qry00
WHERE (((FundPrices_Qry00.Variance)>[Forms]![TrackerForm]![CboTolerance]))
ORDER BY FundPrices_Qry00.Variance DESC;
This is my combo box contained in a form:
The property sheet of the combo box shows the following information
Row Source: "0%";0;"0.10%";0.1;"0.50%";0.5
Bound Column 1
Limit to List Yes
Allow Value List Edits No
Inherit value list No
Show only row source No
In the format data sheet properties I have
Decimal Places 2
Visibles Yes
Column Count 2
Column Widths 0.523cm;0cm
Column heads No
List Width 0.753cm
With 3
The problem I have is when I run the query I dont get the correct results. For instance when I choose 0.50 in my form the query returns values below 0.5. Can someone advice what I am doing wrong, please? I think it might be something related to the usage of logical operators..
Thanks
Jo
I have created a query with fund prices and fund prices variances and I am using a combo box to set up certain criteria in the query. The idea is that a user can select to see funds whose prices have varied 0%, 0.5% etc... This is my query:
SELECT FundPrices_Qry00.Date, FundPrices_Qry00.Fund_Name, FundPrices_Qry00.MCH_Code, FundPrices_Qry00.Variance
FROM FundPrices_Qry00
WHERE (((FundPrices_Qry00.Variance)>[Forms]![TrackerForm]![CboTolerance]))
ORDER BY FundPrices_Qry00.Variance DESC;
This is my combo box contained in a form:
The property sheet of the combo box shows the following information
Row Source: "0%";0;"0.10%";0.1;"0.50%";0.5
Bound Column 1
Limit to List Yes
Allow Value List Edits No
Inherit value list No
Show only row source No
In the format data sheet properties I have
Decimal Places 2
Visibles Yes
Column Count 2
Column Widths 0.523cm;0cm
Column heads No
List Width 0.753cm
With 3
The problem I have is when I run the query I dont get the correct results. For instance when I choose 0.50 in my form the query returns values below 0.5. Can someone advice what I am doing wrong, please? I think it might be something related to the usage of logical operators..
Thanks
Jo