Two Query Questions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bobbie - 30 Nov 2005 14:47 GMT

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

Reply to this Message

KARL DEWEY - 30 Nov 2005 15:41 GMT

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.

> 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

Reply to this Message

Bobbie - 30 Nov 2005 16:12 GMT

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.

Reply to this Message

John Spencer - 30 Nov 2005 16:44 GMT

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 *)

> Karl,
> I'm not sure what you mean by not trying before posting? I've tried
[quoted text clipped - 3 lines]
> want to put in a word and have the results returned for anywhere that
> word was found.

Reply to this Message

Bobbie - 30 Nov 2005 19:14 GMT

John,
Thank you very much. Works perfect!

Reply to this Message