RE: 2nd table need to add more fields other than from the 1st tabl

You will not need to use an array. There are a couple of methods you could
use instead. One would be to manipulate the tables using VBA and
programmatically add new records or update data in existing records of the
second table. Another would be to construct either an append or an update
query, depending on whether you are only adding new rows to table 2 (append)
or modifiying data in table 2 (update). I am guessing it is adding new rows,
so probably an append is in order. then for Update To row of the fields you
need to add, do the calculation.

"Curie" wrote:

> well, I import a txt file into a table in Access. This is the first table.
> Based on information from the first table, and inf. from another table, I
> will need to combine both of them and add a couple more fields . This is why
> I create the new table. I think I should save data from tables into an array
> to manipulate them. Do you know how to do it?
> Thanks
>
> "Klatuu" wrote:
>
> > That first thing you need to consider is you are violating a basic database
> > normalization rule. You should never store calculated values in a table.
> > This is a bad idea for a lot of reasons. On rare occasions, it is reasonable
> > to break this rule, but it is so rare, it is not worth considering.
> >
> > I suggest you rethink your design.
> >
> > "Curie" wrote:
> >
> > > I need to add more fields in the second table. This second table is just a
> > > copy of the first table but adding more fields (i.e., 1st table have these
> > > fields item names, prices and the second table includes item names, prices,
> > > subtotals, total).
> > > Do you know how to do it programming using VBA's recordset and/or array (MS
> > > Access 2000).
> > > Thank you,
.

Relevant Pages

  • Re: cloneNode() not getting script tag content
    ... ID: "IDATE0VIDAUE0V4", Size: "3", Type: "xsd:string", Enum: "false", minLength: "", maxLength: "", Length: "3", minInclusive: "", maxInclusive: "", ... The array contains information that I use for validating the input. ... If you simply keep track of any stuff in fieldData then your script can always add properties there and manipulate subproperties without any need that the browser supports cloning inline script elements and executing the cloned code when the cloned script element is being inserted into the document. ...
    (comp.lang.javascript)
  • [ANN] Rio 0.4.1
    ... = Rio - Ruby I/O Facilitator ... Iterate over the .rb files in a directory and its subdirectories. ... Return an array of the .rb files in a directory and its ... Copy or append a file to a string ...
    (comp.lang.ruby)
  • Re: Writing Array To A Named Range
    ... depending on what happens in the array, which could be a very powerful ... "Dave Peterson" wrote: ... manipulate the data in an array -- not in the range: ... Dim CompetitorOptionsArray As Variant ...
    (microsoft.public.excel.programming)
  • {ANN] Rio 0.4.0
    ... = Rio - Ruby I/O Facilitator ... Iterate over the .rb files in a directory and its subdirectories. ... Return an array of the .rb files in a directory and its ... Copy or append a file to a string ...
    (comp.lang.ruby)
  • Re: Appending text files
    ... > Does anyone know how to append text files using VB? ... text files from SQL Server using DTS. ... The array can contain one or more filenames. ... Dim FileIn As Long ...
    (microsoft.public.vb.general.discussion)