Divide one field (column) into 2 or more in Microsoft Access. A wizard guides you through the process of selecting a field (and table) to be split. The values found in the field will be split by a delimiting (dividing) character of your choice. The necessary amount of new fields will be created with the new split-data.
See also: splitting, access, ms, microsoft, name, address, mdb, fields, records, new, query, data, two, into, full name, table, 2, 1, one, two, second, first, 3, 4, 5, 6, three, four, five, six, more, multiple, rows, columns, adding, add, different, recordset, comma, name, seperate, separate, parts, to, in, how to, half, splitted, splited, parsing, parse, delimited, delim, delimt, text, function, text to columns, setting, form, insert, memo, fullname, contents, values, entries, numbers, count, array, autonumber, city, state, street, spliting, splitting, divide, names, dividing, cut, cutting, slice, slicing, new row, numbers, values, splitter, cells, columns, rows, block, bifurcate, branch, break, burst, cleave, come apart, come undone, crack, dichotomize, disband, disjoin, dissever, disunite, diverge, divide, divorce, fork, gape, give way, hack, isolate, open, part, part company, pull apart, put asunder, rend, rip, rive, separate, sever, splinter, sunder, join, joined, allocate, allot, apportion, carve up, distribute, divide, divvy, divvy up, dole out, go even-steven, go fifty-fifty, go halvesies, halve, parcel out, partition, share, slice, slice up, cavil, chop logic, make a fine distinction, nitpick, pick nits, quibble, refine a distinction, sharpen a distinction, subtilize
|
