Hello.
I have a simple query that prompts the user for the # of transactions and also the low and high credit available.
SELECT [qry_Cardholder Data for RePrice Through Oct 2012].PRIN, [qry_Cardholder Data for RePrice Through Oct 2012].[Account number], [qry_Cardholder Data for RePrice Through Oct 2012].[# of Items], [qry_Cardholder Data for RePrice Through Oct 2012].[FICO 0512], [qry_Cardholder Data for RePrice Through Oct 2012]![Credit Available]/[qry_Cardholder Data for RePrice Through Oct 2012]![Credit Line Amount] AS [Avail Credit %]
FROM [qry_Cardholder Data for RePrice Through Oct 2012]
WHERE ((([qry_Cardholder Data for RePrice Through Oct 2012].[# of Items])>=[> or = # of Transactions]) AND (([qry_Cardholder Data for RePrice Through Oct 2012].[FICO 0512]) Between 0 And 9000) AND (([qry_Cardholder Data for RePrice Through Oct 2012]![Credit Available]/[qry_Cardholder Data for RePrice Through Oct 2012]![Credit Line Amount]) Between [Low Credit Avail %] And [High Credit Avail %]));
When I select .49 and 1.1 for the Low and High Credit Avail % I get anything between 50% and 100%,. but I also get anything under 1%????
If I put Between .49 and 1.1 in the Criteria of the query, it works. However, the criteria changes and I want to provide some flexibility.
Where am I going wrong? Thanks.
I have a simple query that prompts the user for the # of transactions and also the low and high credit available.
SELECT [qry_Cardholder Data for RePrice Through Oct 2012].PRIN, [qry_Cardholder Data for RePrice Through Oct 2012].[Account number], [qry_Cardholder Data for RePrice Through Oct 2012].[# of Items], [qry_Cardholder Data for RePrice Through Oct 2012].[FICO 0512], [qry_Cardholder Data for RePrice Through Oct 2012]![Credit Available]/[qry_Cardholder Data for RePrice Through Oct 2012]![Credit Line Amount] AS [Avail Credit %]
FROM [qry_Cardholder Data for RePrice Through Oct 2012]
WHERE ((([qry_Cardholder Data for RePrice Through Oct 2012].[# of Items])>=[> or = # of Transactions]) AND (([qry_Cardholder Data for RePrice Through Oct 2012].[FICO 0512]) Between 0 And 9000) AND (([qry_Cardholder Data for RePrice Through Oct 2012]![Credit Available]/[qry_Cardholder Data for RePrice Through Oct 2012]![Credit Line Amount]) Between [Low Credit Avail %] And [High Credit Avail %]));
When I select .49 and 1.1 for the Low and High Credit Avail % I get anything between 50% and 100%,. but I also get anything under 1%????
If I put Between .49 and 1.1 in the Criteria of the query, it works. However, the criteria changes and I want to provide some flexibility.
Where am I going wrong? Thanks.
