Search results

Hi, I know how to group and count. I need to know how to update each field. Eg if there are 5 in the group then i will have to update record 1 to 1 record to 2 record to 3 record 4 to record 5 to 5. Then start on the next group. etc

Hi, I'm trying to write some code in Access 2000. What i'm trying to do is count the number of records and update the coloum (Number). At the moment the column Number is blank. (I have just put in test data as example.) What i want to do is count the number of records and update the number...

Hi Thanks for the piece of code i will try it and let you know

Hi does anyone know in how in Access 2000 using VBA, how I can change the name filenames. I have over 100 pictures. I have a table in Access with the old filenames of the pictures and another field with the new names. Eg Old Name New Name Test Test05 Is there anyway to do this in...

Hi i have a whole table full of address which i have extract from Oracle and i want split the addresss in to different fields. Eg Address1, Address2, Town, Country, PoctCode. At present everything is in 1 field. When i have imported the data the Address field looks like below 4 CRESCENT...