crosstab query based on another query question

[hollyh]

i have been usign wizards to do this so bare with me, newbie

I have a crosstab query based off another query and I would like to add "CHF" to each column, is there any easy way to do this? so it would look like "1st Trimester"+CHF

here's the code

TRANSFORM Min(subquery_Analysis_CHF.HeartFailure) AS MinOfHeartFailure
SELECT subquery_Analysis_CHF.ID
FROM subquery_Analysis_CHF
GROUP BY subquery_Analysis_CHF.ID
PIVOT subquery_Analysis_CHF.[Visit Type];
 
SELECT Visits.[Visit Type], Visits.ID, IIf([Heart Failure]="yes","2",IIf([Heart Failure]="no","1","")) AS HeartFailure
FROM Visits
WHERE (((Visits.[Visit Type])="Pre-pregnancy" Or (Visits.[Visit Type])="1st Trimester" Or (Visits.[Visit Type])="2nd Trimester" Or (Visits.[Visit Type])="3rd Trimester"))
ORDER BY Visits.ID;

 

[hollyh]

nm, figured it out.