Re-arrange fields
Re-arrange fields
Is it possible to re-arrange the fields along the top of the tables in a database, to put them in a different order? Or do I have to start over from scratch?
OpenOffice 4.1.9 on Windows 10
Re: Re-arrange fields
@JohnKnee, No. Normally you use a query to retrieve data from a table. In a query you can choose any field order. You do not have to start from scratch: write a query that retrieves the data in correct field order and use that query to create a new table.
It's Microsoft marketing that tells you computers are qualified for non-technicians
W11 22H2 (build 22621), LO 7.4.2.3(x64)
W11 22H2 (build 22621), LO 7.4.2.3(x64)
-
UnklDonald418
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Re-arrange fields
Instead of using the Table Data View to access your data, use the Form Wizard to create a Base form.
A table control on a Base form has far more formatting options and allows you to rearrange the column order using click and drag. When using forms and queries the order of columns in a database table is usually irrelevant.
A table control on a Base form has far more formatting options and allows you to rearrange the column order using click and drag. When using forms and queries the order of columns in a database table is usually irrelevant.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11