Fill down like Excel

[Guest_imported]

Does anyone know of a way to imitate the excel fill down function in Access? or is there any way to do a group modify? Thanks<br><br>Robert

 

[kathryn]

Yes, there is a way.&nbsp;&nbsp;You can use an Update query.&nbsp;&nbsp;If you give us a bit more detail, we can help you through it, or you might want to check out the help files on Update queries; I think they have some good examples.<br> <p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br>

 

[Guest_imported]

I know you can group modify with an update query for all the records in one field.&nbsp;&nbsp;What I want is where a person can go into a form and change a field from NUll to whatever value he/she wants. The only thing with this is that some records with the null field I don't want updated. Therefore I just want a certain number of records updated.&nbsp;&nbsp;For example, I may want to update a field for records 10-30.&nbsp;&nbsp;Thanks for replying.<br><br>Robert<br><br>&nbsp;

 

[kathryn]

You can use criteria in an update query, so you don't have to change all the records in a field.&nbsp;&nbsp;<br><br>Could your user fill out a form with the beginning and ending record numbers, or whatever criteria you want?&nbsp;&nbsp;Then you could give the user a button to click to do the update, and in the code behind the button you would build (and execute) the update query, using the input record numbers to create your WHERE clause.<br><br>I'm not sure if this is what you are looking for, but I hope it helps.<br><br> <p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br>

 

[Guest_imported]

I thought about that, having parameters and putting them in the criteria, but I don't think the users will know what the record numbers are unless they look at the table.&nbsp;&nbsp;They can look at the table and then do it, but I wanted a way pretty much where on a form where I displayed the datasheet view that they could drag and drop down or something to that point.&nbsp;&nbsp;The other problem I have with that is the table that we will be updating is about 70 fields large and if we have a box for all those fields to update then our form will look mighty messy.&nbsp;&nbsp;That's why we prefer a datasheet view. Thanks for helping.<br><br>Robert&nbsp;&nbsp;