Search results

I cannot use an update query since i have a problem with case sensitivity eg. I want to specifically change records that have an "m" and not "M". Therefore i am using "match case" in Find & Replace. regards,

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...

Don't know if it helps.... I'm using Access 2007. Also, I have multiple sales records which will have the same Prod_Class in the sales table. Therefore I won't be able to set a unique primary key in the Sales table, correct?

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?