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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Excel Concatenate with line breaks but ignore blank cells 3
Checking if data exists another table and, if yes, extracting a value 0
Update query with if else condition (need to refer to cell indexes 2
Adding Values From Two Numeric Fields 1
Adding New Record to a linked table from Query 1
blank line in a query for blank lines in a report 4
How to retrieve dates that meets a criteria using Query? Exp Build 1

Back
Top