i know that the syntax for usin DataTextField is : VA.DataTextField = "nameofcolum" but if my request is not simple that mean my request return the result in a colum wich not exist in this case what i should to affect to DataTextField
A:
It's hard to tell what you're looking for here without more information.
If your result set does not contain the column you need, change your result set - alter your query. If you need your datatextfield as a combination of columns, you can iterate through the result set and build the text string based on the column values and assign it as the display value.
senloe
2010-05-27 21:44:11
i don't understand your propositionthis is my query :SELECT V.DESIGNATION+'-->'+V1.DESIGNATION as Voyages FROM VILLES AS V, VILLES AS V1, VOYAGES AS VO WHERE VO.VIL_ID=V.ID And VO.VIL2_ID=V1.IDthe execution of this query in access displays in a colum "Expr1000"this colum not exist in my table so i try this :DataTextField = Expr1000 but not workingcan you more explain your proposition
ZiGi
2010-05-27 22:08:06
Might be a problem trying to alias your column the same name as your table name. Try changing **SELECT V.DESIGNATION+'-->'+V1.DESIGNATION as Voyages** to **SELECT V.DESIGNATION+'-->'+V1.DESIGNATION as Designation** or something like that.
senloe
2010-05-27 23:38:43