i have a simple questions -- do the functions like FORMAT and IIF that can be used in a SELECT clause to modify the results, change the recordset in some significant way?
i am asking this because a dumb grid activex control that i am obliged to use does not display data for columns modified by such functions
e.g. displaying the date in a date column, and not displaying it if i do FORMAT(Date, 'MM/DD/YYYY') AS Date
or not displaying an added column looking like this: IIF(blah > 0, 'P', 'N') AS Type
i've looked into the recordset that i get, the data is there. if i do the same query INTO a temp table and then do a SELECT * FROM temptable, the grid displays all the data correctly. i just dont have a clue what's going on, i am not an access expert (that's why i ask here hehe)