By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,862 Members | 868 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,862 IT Pros & Developers. It's quick & easy.

alias field names sometimes not working in select query

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.