MS Access Help

[glynners]

Could anyone tell me if theres a way to fill a field in with the same number in all records?

If not I'm typing '1' 9145 times into a table :geek

[mathare]

I can't see any sort of Fill option as there is in Excel and Ctrl-D doesn't work either.

Can't help you I'm afraid here Glynners unless copy and paste works across multiple records

[glynners]

I thought as much

Ah well, cheers anyway Mathare :)

[MattR]

Is there anything in the fields already? I'm just wondering if you could use find /replace

[GlosRFC]

Do you have access to the database structure?

http://support.microsoft.com/kb/210236

An alternative would be to use Excel to populate the field by exporting the database using Save As. Use the normal fill or copy option in Excel to fill in that column, then import it back into Access.

[TheOldhamWhisper]

You can use a SQL statement to do this (you need to use an update query).


UPDATE myTable SET myTable.[myRecord] = 1;

should do it. You can got to SQL view and just type it straight in (don't forget the ; )