Drew Jensen wrote:
Good man! Well, i'm able to add another column to the end of the columns by clicking on one of the fields. This adds another column with the name of one of the other columns (the name is the same as the one i clicked on). However none of the fields in this column is editable -- i can't change the name, nor add an alias, nor will the cursor appear in any of the other fields.FamiliaFrazelle wrote:Drew Jensen wrote: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?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]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 thisIf 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]
Are we getting there? :D Have a great afternoon! :)
smime.p7s
Description: S/MIME Cryptographic Signature
