Re: Searching all fields in a record
- From: "Jeff Boyce" <JeffBoyce_IF@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 30 Jun 2005 05:20:19 -0700
Tim
A couple red flags went up when I read your post.
First, a database design that puts values in any field requires searching
"all fields". This sounds very much like ... a spreadsheet, not a
relational database!
Second, have field names that "change from time to time" doesn't sound like
the data structure has been finalized. If you provide some examples, the
newsgroup may be able to offer some suggestions.
Good luck
Jeff Boyce
<Access MVP>
"TimW" <TimW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:61B974D4-607A-4135-91DA-0A353783F300@xxxxxxxxxxxxxxxx
> Is there an SQL statement where I can search all fields in a record
without
> specifying the field names?
>
> such as: Select * from [table] where * is like "whatever"
>
> I would like to use a simple query as the field names can change from time
> to time and I don't want to rewrite this query every time.
>
> Thanks in advance.
>
> TimW
.
- References:
- Searching all fields in a record
- From: TimW
- Searching all fields in a record
- Prev by Date: how to specify a search criteria
- Next by Date: Re: Running total problems (Currently using DSum function)
- Previous by thread: Searching all fields in a record
- Next by thread: Appending records to source and destination tables
- Index(es):
Relevant Pages
|
