How to make an query and select on wether a memo field is empty or not

G

Guest

I have build a table with memo fields. In thismemofield are actions reported. If a memofield is empty (no action) than is should not be mentioned ina report. So i want to create a query on the bases of action mentioned in the memo field. If there is no action then the memo field is empty and it should not be reported

How do i do that?
 
D

Dennis Schmidt

Hi,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

Base your report on a query which has all the fields necessary for the
report, including the Memo field. In the query, in the Memo field column,
on the Criteria line type "Null" (without the quotes). The query should
return only records with values in the Memo field.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Noted Memo Field 4
Dates in a memo field 3
memo field in the select query 2
Memo fields in a query 4
Make Table Query Truncating Memo Field at 255 Characters 2
How can I convert text field to memo field in a query 10
how can I specify text criteria when querying a memo field 1
Can I use totals on one field and still have a memo field? 4

Top