How to hide alias column in SQL Output ?

Question

Hi everyone,

as example, I've the following SQL query ( using Access 2007 )

SELECT ID, FirstMaturityDate, PayMentDate,
       iif(PayMentDate>FirstMaturityDate, PayMentDate, FirstMaturityDate)
           as Maxdate
  from Table 1

Actually, I need the alias Maxdate for further processing, but I don't want to to see Maxdate as column in output. Is this somehow possible ?

Answer 1

Create a view that includes all the columns except the column you want to hide.

Answer 2

You didn't specify how you output the data - if you show it in a form or listbox (for example), just don't display the Maxdate column.
(for example, by just not putting a textbox for it on the form)