Text String Querries... Are they Possible?

[Guest]

Hi,

At work we are required to submit a word document at the end of each shif
called a shift report. It ususally consists of about 15 to 20 short
individual notes of events that happend during the day.

We all have Microsoft Access and I am wondering if it may be possible to
enter each note individually in Access as a record and print the shift report
from that. I would like to be able to develop a database of notes that would
let us query all the short notes and find all notes that contain key words
like an employees name or the name of a piece of equipment.

I would want this set up so that employees who do not know how to use Access
would be able to query their notes using some sort of form where you could
enter the key word and Access would then return all notes with that key word.

If the data is stored in Text format is it better than Memo other than the
255 character limit? Can both text and memo strings be querried for keywords
in the same fashion? Can text strings be querried at all? I know that access
could create a report based upon names of people or equipment if that data
was entered in its own field but I want to pull the records from keywords
found in strings of text.

I know next to nothing about Microsoft Access but was wondering if this is
something easy to put together if I put the time in to learn the program.

I am very good with computers otherwise.



Quin

 

[Douglas J. Steele]

Both Text and Memo fields can be queried.

If you want to be able to provide a snippet of text, and look for its
occurrence anywhere in the string, you need to use the Like clause, together
with the appropriate wildcard (* if you're using DAO, % if ADO)