How to change the label of column in a Query

[Bre-x]

Hi,

I need to change the column lebel in a query:

Example

Expr1: [Donation_Amount]

Expr1
$100
$200

to

MyFunction(2) = [Donation_Amount]

so that i get

Member Donation
$100
$300

 

[vsingler]

I believe you can change a column label in a query by
replacing the Expr1: portion of your label with Member
Donation: so that your expression reads Member Donation:
[Donation_Amount] in the QBE grid.

Typing the name you want followed by a : changes the label
that is displayed when the query runs.

Hope this helps,

Val

 

[Bre-x]

Hi Val, thanks for your comment.

The problem is that it will not always be "Member Donation". It will
change.
That's way i wanted to include a function so i get the string from a Table.

Speaking about tables, i think the way to go here is to create a Temp Table
with the Columns Names using SQL create table ...... then update the
amounts with an update query.

Thanks,

Bre-x