ms access 2007 - How to hide alias column in SQL Output? -
As an example, I have the following SQL query (using Access 2007)
SELECT ID, First Metayat date, payment date, IIF (payment date and first) metire date, payment date, first metayat date) is as Maxed as Table 1. In fact, I need the nickname Maxdate for further processing, but I do not want to see MaxDate as a column in the output. Is it possible anyway?
You did not specify how you output data - if you show it a form or listbox (For example), simply do not display the max. Column.
(for example, by not having a text box for it for the form)
Comments
Post a Comment