If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table field names to appear alphabetically
Hi,
I have just started doing queries in access on our accounting database and I would like to know is there a way I can get the tables in the query to list all the fields alphabetically. It does it automatically when I do a query using excel Thanks |
#2
|
|||
|
|||
Table field names to appear alphabetically
On Mon, 1 Mar 2010 17:36:01 -0800, Simon S
wrote: Hi, I have just started doing queries in access on our accounting database and I would like to know is there a way I can get the tables in the query to list all the fields alphabetically. It does it automatically when I do a query using excel Thanks The order of fieldnames in a table - or a query - should be irrelevant. The Query will reflect the order of fieldnames in the table (which you can alphabetize manually), but you should not be looking at either table *or* query datasheets in any case. Tables are for storing data; queries are for selecting and sorting data; Forms are for viewing and editing data; Reports are for printing. You can lay out the controls in any order you like - alphabetically, by importance, in logical groups, whatever - on a form or report. Could you explain how your tables are structured, and what benefit you expect from alphabetizing fieldnames? -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Table field names to appear alphabetically
They are linked tables to the accounting software and tables often contain
over 100 fields. I select the fields to include in my query in a particular order e.g. ITM_NO (the item number), ITM_DES (the item no's description), ITM_PRESUP (preferd supplier), ITM_USER1 (user information), ITM_CAT (the product category) etc. I normally select 45 fields to be included in the query. When I do a query using microsoft query in excel it lists the fields in the table alphabetically e.g ITM_BUY ITM_CAT ITM_CLASS ITM_CREATED ITM_PRESUP ITM_USER1 etc (this makes it much eaiser (because they are in alphabetical order) to select the fields from the table to include in the query. The table in access has the fields in no particular order e.g. ITM_CREATED ITM_BUY ITM_PRESUP ITM_CLASS ITM_USER1 ITM_CAT and so on, I just want to know if I can get access to display trhe fields in the table alphabetically. "John W. Vinson" wrote: On Mon, 1 Mar 2010 17:36:01 -0800, Simon S wrote: Hi, I have just started doing queries in access on our accounting database and I would like to know is there a way I can get the tables in the query to list all the fields alphabetically. It does it automatically when I do a query using excel Thanks The order of fieldnames in a table - or a query - should be irrelevant. The Query will reflect the order of fieldnames in the table (which you can alphabetize manually), but you should not be looking at either table *or* query datasheets in any case. Tables are for storing data; queries are for selecting and sorting data; Forms are for viewing and editing data; Reports are for printing. You can lay out the controls in any order you like - alphabetically, by importance, in logical groups, whatever - on a form or report. Could you explain how your tables are structured, and what benefit you expect from alphabetizing fieldnames? -- John W. Vinson [MVP] . |
#4
|
|||
|
|||
Table field names to appear alphabetically
The only way to display the fields in alpha order is to move them around in
the table. You can drag and drop fields in table design view to rearrange them. But since you are linking to accounting software I would guess that is not allowed. An option is to build base queries with the fields in alpha order and then use that base query for all your queries. So if you had a table ITEMS, you would create a query named qItems and add the fields to that query in the desired order. Do not apply any criteria to this query. Then in all your new queries, you could use qItems instead of the Items table. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Simon S wrote: They are linked tables to the accounting software and tables often contain over 100 fields. I select the fields to include in my query in a particular order e.g. ITM_NO (the item number), ITM_DES (the item no's description), ITM_PRESUP (preferd supplier), ITM_USER1 (user information), ITM_CAT (the product category) etc. I normally select 45 fields to be included in the query. When I do a query using microsoft query in excel it lists the fields in the table alphabetically e.g ITM_BUY ITM_CAT ITM_CLASS ITM_CREATED ITM_PRESUP ITM_USER1 etc (this makes it much eaiser (because they are in alphabetical order) to select the fields from the table to include in the query. The table in access has the fields in no particular order e.g. ITM_CREATED ITM_BUY ITM_PRESUP ITM_CLASS ITM_USER1 ITM_CAT and so on, I just want to know if I can get access to display trhe fields in the table alphabetically. "John W. Vinson" wrote: On Mon, 1 Mar 2010 17:36:01 -0800, Simon S wrote: Hi, I have just started doing queries in access on our accounting database and I would like to know is there a way I can get the tables in the query to list all the fields alphabetically. It does it automatically when I do a query using excel Thanks The order of fieldnames in a table - or a query - should be irrelevant. The Query will reflect the order of fieldnames in the table (which you can alphabetize manually), but you should not be looking at either table *or* query datasheets in any case. Tables are for storing data; queries are for selecting and sorting data; Forms are for viewing and editing data; Reports are for printing. You can lay out the controls in any order you like - alphabetically, by importance, in logical groups, whatever - on a form or report. Could you explain how your tables are structured, and what benefit you expect from alphabetizing fieldnames? -- John W. Vinson [MVP] . |
#5
|
|||
|
|||
Table field names to appear alphabetically
Thanks
"John Spencer" wrote: The only way to display the fields in alpha order is to move them around in the table. You can drag and drop fields in table design view to rearrange them. But since you are linking to accounting software I would guess that is not allowed. An option is to build base queries with the fields in alpha order and then use that base query for all your queries. So if you had a table ITEMS, you would create a query named qItems and add the fields to that query in the desired order. Do not apply any criteria to this query. Then in all your new queries, you could use qItems instead of the Items table. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Simon S wrote: They are linked tables to the accounting software and tables often contain over 100 fields. I select the fields to include in my query in a particular order e.g. ITM_NO (the item number), ITM_DES (the item no's description), ITM_PRESUP (preferd supplier), ITM_USER1 (user information), ITM_CAT (the product category) etc. I normally select 45 fields to be included in the query. When I do a query using microsoft query in excel it lists the fields in the table alphabetically e.g ITM_BUY ITM_CAT ITM_CLASS ITM_CREATED ITM_PRESUP ITM_USER1 etc (this makes it much eaiser (because they are in alphabetical order) to select the fields from the table to include in the query. The table in access has the fields in no particular order e.g. ITM_CREATED ITM_BUY ITM_PRESUP ITM_CLASS ITM_USER1 ITM_CAT and so on, I just want to know if I can get access to display trhe fields in the table alphabetically. "John W. Vinson" wrote: On Mon, 1 Mar 2010 17:36:01 -0800, Simon S wrote: Hi, I have just started doing queries in access on our accounting database and I would like to know is there a way I can get the tables in the query to list all the fields alphabetically. It does it automatically when I do a query using excel Thanks The order of fieldnames in a table - or a query - should be irrelevant. The Query will reflect the order of fieldnames in the table (which you can alphabetize manually), but you should not be looking at either table *or* query datasheets in any case. Tables are for storing data; queries are for selecting and sorting data; Forms are for viewing and editing data; Reports are for printing. You can lay out the controls in any order you like - alphabetically, by importance, in logical groups, whatever - on a form or report. Could you explain how your tables are structured, and what benefit you expect from alphabetizing fieldnames? -- John W. Vinson [MVP] . . |
Thread Tools | |
Display Modes | |
|
|