Use expression for field header

[leejayd]

Hi,

I'm writing a group by query to transform data and need to use an expression to set a column header such as max(Date([cDate]) : [Cost]

I've had no joy with this so far, is it possible?

 

[plog]

Maybe. Can you post some sample data? Include what the data looks like before and then based on that data what the result should look like. Be sure to post table and field names.

 

[Simon_MT]

The simplest way is to change the Label to a Text box.

Simon