Finding a particular date in a memo field

  • Thread starter Thread starter Ilan
  • Start date Start date
I

Ilan

hi,
i have a memo field which stores information about payment
history. i want to search that particular field in the
query and pull anything from july, 2004. what is the SQL
code to do this or how else could i do this.

thanks,
Ilan
 
You can't do this well using a memo field. How are the dates input in the memo
field? July 1, 2004???

Need some sample data to work this out, but the first thing to try MIGHT be

LIKE "*July *#, 2004*"

That should get anything that matches the pattern JULY followed by a space and
one number and a comma and a space and 2004. But that could produce a match on
July 1, 2003 August 2, 2004

So a bit better would be

Memofield Like "*July #, 2004*" OR memofield like "*July ##, 2004*"

As far as how else to do it, you would be better off if you had a separate table
for payments that stored the payment, the date, and a field that specified the
invoice or loan or whatever the payment was attached to.

Then the search would be fairly trivial.
 
Back
Top