![]() ![]() ![]() The array can be one-dimensional, or two-dimensional, controlled by rows and. Doing something like this in Excel is so obvious, but not so in Access, but neverthless can. Note: When you select a range of cells that you want to repeat in adjacent cells, you can drag the fill handle down a single column or across a single row, but not down multiple columns and across multiple rows. Enter this formula: IF (A2<>A1,1,B1+1) into a blank cell which beside your data, B2, for instance, see screenshot: 2. The SEQUENCE function generates a list of sequential numbers in an array. The RecordID would be a sequential number starting from.![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |