Access Tables

[pianoboy11]

Table 1: has the raw data.



table 1 fields are

Index , OpStamp , UutMSN , OID , Etag ,EDesc, Estamp1 , Etamp2, Evalue


Table 2: is going to be the record count , counting how many etags occurred per UutMsn. table 2 is blank at the moment.


Table 2 fields are

Optamp , UutMSN , Etag ------------> errors across horizontally

So my question is how do i link, or perform the count from table 1 etag column into table 2.

Can someone assist me? Do I enter the data by code or Access automatically extracts the data from table 1 and perform the record via query. Im new to access.

Can someone post me a tutorial

[NTC]

fundamentally your question is unclear; In order to count records - one does not need a second table. One would perform an Aggregate Query (look for the epsilon E in the tool bar). Obtain an Access textbook in the version that you have - these can be found in any big box bookstore or at Amazon and explore this feature in query design.

[pianoboy11]

So my question is base on the table1, is there a way to just simply get a recordcount and import to table2 from the raw data thats in table1.


I posted my table1 in a picture so you can see whats going on.

Now in the table1 im only curious of how many times Etags occured per UutMSN.

so in my table2 which is going to be the record count table of occured etags

The etags that occur are going to be columns headers now in the new table

so my table2 design is going to be set up like this below which is datagridview2

UutMSN F000 F001 3757 etc.................
----------------------------------------------------------
2261MSN 3 1 2

1368MSN 0 3 1

3445MSN 3 2 0
-----------------------------------------------------------

This is a example of the recordcount table recording how many times each Etag occured

F000 , F001 3757 are etags, if you look in the file i attach below you will see what im talking about

Can you assist me , Im keeping count of whats happening in table1 under the etag column

and recording it in my new table 2 without manually putting them in