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 |
#11
|
|||
|
|||
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/ |
#12
|
|||
|
|||
Aliases or synonyms fields
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. |
#13
|
|||
|
|||
Aliases or synonyms fields
"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 |
#14
|
|||
|
|||
Aliases or synonyms fields
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 |
|
Thread Tools | |
Display Modes | |
|
|