ADDING NEW BLANK COLUMN W/MAKE TABLE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an expression to add a new blank column in a make table? Say for
future users to add comments to a line item.
 
In your make table query , in one of the columns enter a field name followed
by a se of quotes . Syntax is test:" " This should give you a column with
no info in it.

Tony
 
That works, thanks! I'm creating the new column to append a [NEW] table to
the [OLD]. This is the only way I know how to do the following. But you may
know of a better way to do this.

I have two tables [OLD] & [NEW]. I would like to query any changes from the
old to the new. In the example below, SKU 12346 changed to 60, 12347 is not
in the [NEW] table, 12348 is added in the [NEW] table.

SKU OLD VALUE
12345 85
12346 70
12347 85

SKU NEW VALUE
12345 85
12346 60
12348 90

SKU OLD NEW CHANGED
12345 85 85
12346 70 60 Y
12347 85 Y
12348 90 Y
 
Back
Top