L leejayd New member Local time Today, 02:00 Joined Jul 22, 2014 Messages 1 Jul 22, 2014 #1 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?
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?
P plog Banishment Pending Local time Yesterday, 20:00 Joined May 11, 2011 Messages 12,055 Jul 22, 2014 #2 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.
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.
S Simon_MT Registered User. Local time Today, 02:00 Joined Feb 26, 2007 Messages 2,170 Jul 22, 2014 #3 The simplest way is to change the Label to a Text box. Simon
