Search results

I have table that has more than 2M records, on an Access 97 Access database. I am trying to replace the letter 'm' in a particular field with 'Me'. I noticed that after an x amount of records Access stops and gives this message: " You can't replace the current value of the field with the...

I am building a select query. My query contains 2 tables: 1 table has product codes and the other has product sales. Table 1: Product code table - contains these fields and sample records: Prod_Class Prod_Desc t Inbound T Outbound r Local R...

I have been using Access for quite some time and never used Relationships or Primary keys. I join tables/queries in the query design. Does this mean that I am not using Access in the correct way? regards,

I would like to Average multiple fields in a query. For example I would like to Avg [Field1], [Field2] & [Field3]. How can I do it?