Two Query Questions

  • Thread starter Thread starter Bobbie
  • Start date Start date
B

Bobbie

1.Can you do a parameter query on a Memo field?
2. Can I set up a query to find all records that do not have a date in
the field.

As you can probably tell, I have tried but have not been successfull
yet. Thank you for your time
 
1. Yes. Why did you not just try it first before posting?

2. Are you asking about a date in a memo field or a datetime field? For a
datetime just check for null. The only way to check in a memo field that I
know of is to know the date and the format used as it is stored as text in
the memo field.
 
Karl,
I'm not sure what you mean by not trying before posting? I've tried
several things. As for generating a query on a null date, I figured
that out by using the IS Null in the criteria. As for the the memo
field, this wouldn't have anything to do with a date or time. I just
want to put in a word and have the results returned for anywhere that
word was found.
 
To find a records where the memofield contains a specified string you would
use Like and wildcard characters.


Field: YourMemoField
Criteria: LIKE "*" & [Find What?} & "*"

You can just hard code this as
Criteria: LIKE "*Bobbie*"

* = Any number of characters (from 0 up) (in ADP use % versus *)
 
Back
Top