Query of calculated field gives blank.

[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?

 

[neileg]

I don't understand why you want to do this. Your calculated field does not exist until the first query runs. Simply create a query that contains your calculated field only.

 

[grnzbra]

I need to create a union query to join one table that has that value in the field and another table that has the component parts. When I ran the union query, the results from the calculated field were blank, so I set up a straight select query to debug it and found I wasn't getting anything there either.

However, while I was futsing (Functional Test Sequence) with it, it started working. I have no idea what I did.