Query of calculated field gives blanks

[grnzbra]

I have the following calculated field in a query:

LoanNo:IIf([Stats].[LoanCnt]>1,[Stats].[LoanCnt] & " Loans",[Loan].[LnNo])

Within its query, it correctly displays the loan number associated with a particular loan.

However, when I run a second query

SELECT LoanNo
FROM qryLoanInfo

it comes up blank for every record (other fields are OK)

Does anyone have any idea what might be happening?

 

[randy700]

Can you post the SQL code for both queries?


Randy

 

[grnzbra]

Thank you.
I'm not sure what I did, but while I was futsing around with it, it started working.