Re: parameter

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 01/29/05 

Date: Sat, 29 Jan 2005 09:06:28 -0600

al9315 wrote:

>Typed question earlier - cannot find it on here ???????
>Query - Record Collection - e.g. "We wish you a Merry Xmas" - Parameter
>Query - type in e.g. Merry Xmas - search ALL track fields (in my case - 24
>fields) in ALL records for any instance of tracks with "Merry Xmas" in ?

24 track fields???

Searching such an unnormalized structure will be a nightmare
and might even exceed some limits.

Before you get too much further down this road, take the
time now to create a more relational table structure. You
should have a separate table for the tracks that has a field
for the title along with a field with the foreign key to the
records table.

This kind of structure is trivial to search since there is
only one field to search. 

-- 
Marsh
MVP [MS Access]