FamiliaFrazelle wrote:
Drew Jensen wrote:
You add ( type in ) the calculation to the first open cell on the
right on the row named "Field"
You add the Alias in the cell just below this - on the row named "Alias"
( in English anyway )
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Thanks, Drew! Aha! This is what the "problem" is. i have no
"first open cell on the right". Should i add that this query is the
union/join of two tables? Maybe this is where the problem lies. Do i
have to first create a query on each table and then join them?
Have a great morning! :)
Now I am a bit lost.
You can create / edit a query definition in Base in two modes - The GUI
designer ( that is the mode in the screen shot ) or in SQL mode. In the
later you just have a very basic text control that allows you to enter
any valid SQL statement that returns a record set.
or Maybe it is this
If you are in the GUI designer there are only 20 columns displayed for
field namesm etc...if you exceed this by double clicking on a 21st field
name a new row is added, but not a blank one...so just double click on a
field name in the the table list box..add a column to the grid at the
bottom and then use that new column for your entry...
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
