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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top