Re: Loop for Table
From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 02/14/04
- Next message: Jade: "graphics"
- Previous message: LB: "Data in Table 'lost'!!"
- In reply to: Allison: "Loop for Table"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 14 Feb 2004 22:40:18 +0000
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.
On Wed, 11 Feb 2004 12:44:43 -0800, "Allison" <haynesa99@yahoo.com>
wrote:
>
>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 data*** view I would like
>to automatically see a field called Full Grant# Currently,
>my table name is :tbl1:IMPAC II
-- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.
- Next message: Jade: "graphics"
- Previous message: LB: "Data in Table 'lost'!!"
- In reply to: Allison: "Loop for Table"
- Messages sorted by: [ date ] [ thread ]
