'Overflow' Message on a Query

[Moxioron]

Hello.

I put together a query (see SQL below) and it worked great until I put criteria for the Percent Available Expression. I only want the query to return 25% or greater.

Where am I going astray?

Thank you.

SELECT [tbl_Card Holder Journal Report_Update].[Account Identifier], [tbl_Quest Scores May 2012].[Member Number], [tbl_Quest Scores May 2012].[Primary Name], [tbl_Card Holder Journal Report_Update].[Address Line One Text], [tbl_Card Holder Journal Report_Update].[Address Line Two Text], [tbl_Card Holder Journal Report_Update].[Address City Name], [tbl_Card Holder Journal Report_Update].[Address State Name], [tbl_Card Holder Journal Report_Update].[Address Postal Code], [tbl_Quest Scores May 2012].[Open Date], [tbl_Card Holder Journal Report_Update].[Credit Available Amount], [tbl_Card Holder Journal Report_Update].[Account Balance Total Amount], [tbl_Card Holder Journal Report_Update].[Credit Line Amount], [tbl_Card Holder Journal Report_Update]![Credit Available Amount]/[tbl_Card Holder Journal Report_Update]![Credit Line Amount] AS [Percent Available], [tbl_Quest Scores May 2012].[FICO 0512], Mid([Account Identifier],5,4) AS PRIN, [tbl_Estatement Enrollment].[E-mail Address]
FROM [tbl_Estatement Enrollment] RIGHT JOIN ([tbl_Quest Scores May 2012] INNER JOIN [tbl_Card Holder Journal Report_Update] ON [tbl_Quest Scores May 2012].[Card Number] = [tbl_Card Holder Journal Report_Update].[Account Identifier]) ON [tbl_Estatement Enrollment].[Card Number] = [tbl_Quest Scores May 2012].[Card Number]
GROUP BY [tbl_Card Holder Journal Report_Update].[Account Identifier], [tbl_Quest Scores May 2012].[Member Number], [tbl_Quest Scores May 2012].[Primary Name], [tbl_Card Holder Journal Report_Update].[Address Line One Text], [tbl_Card Holder Journal Report_Update].[Address Line Two Text], [tbl_Card Holder Journal Report_Update].[Address City Name], [tbl_Card Holder Journal Report_Update].[Address State Name], [tbl_Card Holder Journal Report_Update].[Address Postal Code], [tbl_Quest Scores May 2012].[Open Date], [tbl_Card Holder Journal Report_Update].[Credit Available Amount], [tbl_Card Holder Journal Report_Update].[Account Balance Total Amount], [tbl_Card Holder Journal Report_Update].[Credit Line Amount], [tbl_Quest Scores May 2012].[FICO 0512], [tbl_Estatement Enrollment].[E-mail Address]
HAVING ((([tbl_Card Holder Journal Report_Update]![Credit Available Amount]/[tbl_Card Holder Journal Report_Update]![Credit Line Amount])>0.24) AND (([tbl_Quest Scores May 2012].[FICO 0512])>699 And ([tbl_Quest Scores May 2012].[FICO 0512])<9000));

 

[SydneyGeek]

Do any of the lines have a Credit line Amount of 0?
Division by 0 will give you an overflow error or a DIV/0 error.

That being the case you can filter out 0 values by putting

WHERE [tbl_Card Holder Journal Report_Update]![Credit Line Amount]<>0 OR [tbl_Card Holder Journal Report_Update]![Credit Line Amount] IS NOT NULL

just before the GROUP BY clause

Denis