Re: Query question

Tech-Archive recommends: Speed Up your PC by fixing your registry


Sure, We have an archives database that includes a variety of
materials. There are for example letters - the letters have from and
to fields, they also have a subject fields, and they have a donated by
field. I want all cases in which Smith is in the from or the to or the
aubject or the donated by fields, or in some cases I may be looking for
Smith to find nee Smith. The relationship is the collection to the
individual pieces - which folder belongs to which, what the material
types are. However, these fields are and should be distinct, I just
need to search among all fields to find Smith. In terms of using the
database to collect information about the collection and maintaining
the relationship among materials I am having no problem. I guess I
don't understand why I can open a table and do a Find and get this
information but I can not construct a very easy query


--
wkomorow
------------------------------------------------------------------------
wkomorow's Profile: http://www.msusenet.com/member.php?userid=1310
View this thread: http://www.msusenet.com/t-1870435537

.

Relevant Pages

  • Re: One at a time, or several always in progress???
    ... As you know i am now writing, or rather translating personal docs [ ... Fiber materials ... books mags, catalogs, letters. ...
    (rec.crafts.textiles.yarn)
  • Re: Pyramid stone?
    ... > Sand is one of the better materials to build a road bed on as ... > long as there is no rain. ... Smith also mentions that a large component of the Giza ramp material is ... of the sledge runners. ...
    (sci.archaeology)