Problem with retreiving dates in memo text box

S

STEFANOS KARAMETOS

I've created a form with a memo text box. Into the memo i write down dates
and details fom specific dates. I want to design a query which will return to
me from all records specific dates and off course details from these dates
too that i decide. I tried the following but it returns everything back. The
code i tried is:

Criteria:[date?] Like "??/??/????"

Any help on this?
 
M

Marshall Barton

STEFANOS said:
I've created a form with a memo text box. Into the memo i write down dates
and details fom specific dates. I want to design a query which will return to
me from all records specific dates and off course details from these dates
too that i decide. I tried the following but it returns everything back. The
code i tried is:

Criteria:[date?] Like "??/??/????"
Click to expand...


That's not going to work. Packing multiple values into a
single field is a gigantic NO-NO in a database, any
database, even an Excel database.

Instead you need to have another table with fields for the
date and detail. then you can query that table very easily.
 
Top