Loop for Table

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

Is it possible to create a loop that will open my linked
Microsoft Excel table and insert a column called Full
Grant Number that concatenates the pre-existing fields in
the table called Full Grant and CAN(Common Account Number).
How would one write a loop against a linked table to
accomplish the above?


Full Grant # = Grant# + CAN (Insert one column into table)
everytime I open my table in datasheet view I would like
to automatically see a field called Full Grant# Currently,
my table name is :tbl1:IMPAC II
 
Hi Allison,

This is rather difficult and quite unnecessary. Instead, create a query
based on the linked table. In query design view, add a calculated field
like this:
Full Grant Number: [Full Grant] & [CAN]
and then use the query wherever you want the concatentated Full Grant
Number to be available.
 
Back
Top