Originally Posted by
nishezaman
Hi All
I am new to Access. I have a table of 5 fields and more than 100,000 records(rows). I need to fill a certain range of rows(example 4,500 - 95061) under a specific field (column) with a fixed data say 12:05 AM. Could you help me how to do it? If I need any VB function please let me know the codes. Example:
ID Fld1 Fld2 Fld3 Fld4 Fld5
1 2 3 5 7 9
..
4500 4 3 4 5 10
...
95061 2 4 5 6 7
Now I need to replace data's for ID 4500 - 95061 under Fld3 with "12:05 AM"
Thanks
You would write an update query as follows:
Code:
UPDATE NameOfTableToBeUpdated SET NameOfTableToBeUpdated.Field5 = #12:05 AM# 'Field5 MUST BE a Date Field
WHERE (((NameOfTableToBeUpdated.FieldThatHasNumber) Between StartingValue And EndingValue))