How to change the label of column in a Query

  • Thread starter Thread starter Bre-x
  • Start date Start date
B

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
 
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
 
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
 
Back
Top