473,321 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

alias field names sometimes not working in select query

Acces 2000:
I have several 'lookup' type tables with a standard field naming
convention of id(pk) and name in a medium sized database. When I
create a select query involving 3 or 4 of these tables for example, I
have found that the alias name does not always appear as I would
expect.

For example, in the query design grid, if I use something like
ManufacturerId: id (table row shows tblManufacturer) or
ManufacturerId:tblManufacturer!id - the query runs fine, but the field
name is id.

The sql source is as I would expect: Along the lines of SELECT
tblManufacturer!id AS ManufacturerId FROM tblManufacturer...

Any input gratefully received.
Nov 12 '05 #1
2 44376
Open tblManufacturer in design view, and select field it.
Is there anything in the Caption property?
If so, Access displays the caption over the column rather than the field
name/alias.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Craig" <to**********@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
Acces 2000:
I have several 'lookup' type tables with a standard field naming
convention of id(pk) and name in a medium sized database. When I
create a select query involving 3 or 4 of these tables for example, I
have found that the alias name does not always appear as I would
expect.

For example, in the query design grid, if I use something like
ManufacturerId: id (table row shows tblManufacturer) or
ManufacturerId:tblManufacturer!id - the query runs fine, but the field
name is id.

The sql source is as I would expect: Along the lines of SELECT
tblManufacturer!id AS ManufacturerId FROM tblManufacturer...

Any input gratefully received.

Nov 12 '05 #2
Yes - this is the reason - many thanks Allen.
"Allen Browne" <al*********@SeeSig.invalid> wrote in message news:<fX*******************@news-server.bigpond.net.au>...
Open tblManufacturer in design view, and select field it.
Is there anything in the Caption property?
If so, Access displays the caption over the column rather than the field
name/alias.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Craig" <to**********@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
Acces 2000:
I have several 'lookup' type tables with a standard field naming
convention of id(pk) and name in a medium sized database. When I
create a select query involving 3 or 4 of these tables for example, I
have found that the alias name does not always appear as I would
expect.

For example, in the query design grid, if I use something like
ManufacturerId: id (table row shows tblManufacturer) or
ManufacturerId:tblManufacturer!id - the query runs fine, but the field
name is id.

The sql source is as I would expect: Along the lines of SELECT
tblManufacturer!id AS ManufacturerId FROM tblManufacturer...

Any input gratefully received.

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bill Kratzer | last post by:
Hi... I am currently working on a Java-based product that is backed by PostgreSQL (among other databases). I have noticed that PostgreSQL appears to truncate column alias names after 31...
3
by: Andrew | last post by:
With command-line interface ( 3.23.37, UNIX Socket ) all is well with column aliasing. However, column aliases disappear in Excel, over ODBC, when there are multiple (joined) tables in the query. ...
5
by: malcolm | last post by:
Example, suppose you have these 2 tables (NOTE: My example is totally different, but I'm simply trying to setup the a simpler version, so excuse the bad design; not the point here) CarsSold {...
14
by: John | last post by:
Hi all, I am doing the change from having worked in Oracle for a long time to MS SQL server and am frustrated with a couple of simple SQL stmt's. Or at least they have always been easy. The...
3
by: A.V.C. | last post by:
Hello, I found members of this group very helpful for my last queries. Have one problem with CASE. I can use the column name alias in Order By Clause but unable to use it in WHERE CLAUSE. PLS...
6
by: Larry R Harrison Jr | last post by:
I have a database I'm designing in Access 97. I have a custom field in a query which looks in {Table of Documents} and shows them all. It then needs a "latest revision number," stored in another...
1
by: sdot | last post by:
a query is working at first,,then when i add an aliase to a table, it doesnt work..this is using the SQL view for querying in MS Access 2002 (XP)........ for example SELECT invoice_id,...
9
by: sellcraig | last post by:
Microsoft access 2 tables table "data main" contains a field called "code" table "ddw1" is created from a make table query of "data main" Goal- the data in "code" field in needs to...
5
by: rdemyan via AccessMonster.com | last post by:
I have a need to add another field to all of my tables (over 150). Not data, but an actual field. Can I code this somehow. So the code presumabley would loop through all the tables, open each...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.