Re: What queried should I use???
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 21 Feb 2007 11:17:59 -0700
On Wed, 21 Feb 2007 07:59:31 -0800, Lee
<Lee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi John,
Thanks for answering my question. Is there a better way to write the SQL
since I have different kinds of range of account (they are not in sequence)?
I have 200 so accounts far. And it's very tedious to write each of the
account number in the Union query every time.
Where is this wide-flat data coming from? Surely you're not
INTENTIONALLY storing a table with account numbers as fieldnames?
What's the context? If we can figure out why you need to do this in
the first place, maybe we can find way to automate the process of
normalizing it.
John W. Vinson [MVP]
.
- References:
- Re: What queried should I use???
- From: John W . Vinson
- Re: What queried should I use???
- Prev by Date: Re: Query sorting problem
- Next by Date: Re: Filter by date on a field that uses now()
- Previous by thread: Re: What queried should I use???
- Next by thread: Re: What queried should I use???
- Index(es):
Relevant Pages
|
