Aliases or synonyms fields

=?Utf-8?B?RGVubmlz?= wrote in
:

I've been using
relational db for over 20 years on large to mid-range machines and
I am just learning Access.

Whatever db you were using seems to have taught you non-standard
terminology. Access is closer to the standard than the terms in
which you worded your original post.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Dennis,

Long story short, what you now describe sounds fine.

Although the given reason (getting the expression reliably repeated in the
multiple places that need it) seems like something that could be more easily
handled via other means, such as copy and-paste the expression.

I have a few application where I base queries on a query. The typical use
is when I have a particular condition / criteria where many queries would
have that as one of their conditions.

Example: A membership database which lists both current and past members.
And about 10 queries which search for a subset of current members. Rather
then put "current" as a condition into all 10 queries, I make one query which
selects for current members, and use it as the record source for the 10
queries.

"Dennis" wrote in message
...
All,

My plan is to define a general query will all of my actual fields along
with
all of my defined fields. This query would have no sort or selection
(where)
criteria. Then all subsequent queries would be based on my general query
and
those queries would have the sort and select criteria. Is this a bad
approach in Access?


I've never had a problem with such an apporach.

Keith.
www.keithwilby.co.uk

All,

I appreciate all of the comments and the helps. As I said, I'm still
learning the Access terminology so I apologize if I did not use the correct
terms.

But yes, what I'm trying to accomplish is to create a logical view of the
table with all of my computed fields in that view.

It is true that I could copy and paste my computed field into other queries,
but it I want to change one of those computed field, I would have to change
all of the places to where I copied it. If I leave it in one place and have
everything reference it, I only have to make one change.

Once again, thanks for all of the advice and assitance. It is greatly
appreciated.

Dennis
--
Dennis


"Keith Wilby" wrote:

"Dennis" wrote in message
...
All,

My plan is to define a general query will all of my actual fields along
with
all of my defined fields. This query would have no sort or selection
(where)
criteria. Then all subsequent queries would be based on my general query
and
those queries would have the sort and select criteria. Is this a bad
approach in Access?


I've never had a problem with such an apporach.

Keith.
www.keithwilby.co.uk