B bott Mar 18, 2004 #1 I'm trying to output the results of a query to Excel, but with the results formatted per our needs. Any leads on how to do this
I'm trying to output the results of a query to Excel, but with the results formatted per our needs. Any leads on how to do this
J John Vinson Mar 18, 2004 #2 I'm trying to output the results of a query to Excel, but with the results formatted per our needs. Any leads on how to do this Click to expand... Use the FOrmat() function in the query to create calculated fields, as text strings, and export them rather than exporting the query directly. For example, if you have a date/time field, put ExpDate: Format([datefield], "dd-mmm-yyyy") to get dates exported as 3-Mar-2004.
I'm trying to output the results of a query to Excel, but with the results formatted per our needs. Any leads on how to do this Click to expand... Use the FOrmat() function in the query to create calculated fields, as text strings, and export them rather than exporting the query directly. For example, if you have a date/time field, put ExpDate: Format([datefield], "dd-mmm-yyyy") to get dates exported as 3-Mar-2004.
