Syntax Help Needed for Using AND Statement in NEXIF

macropod · #1 05-06-2011, 10:01 AM

Hi Rob,

You've got the basic construction OK. The code says to skip the record if any of the fields 1-4 is empty. Is that what you're trying to achieve?

robpgreer · #2 05-06-2011, 10:11 AM

Quote:

Originally Posted by macropod

The code says to skip the record if any of the fields 1-4 is empty. Is that what you're trying to achieve?

I'd like it to skip if ALL of them are empty. Otherwise I want it to print.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't seem to get the correct syntax for Wine list mailmerge	daym	Mail Merge	3	05-02-2011 03:26 AM
Help with IF Statement	limpbizkit	Excel	4	02-24-2011 09:16 PM
if statement	piper7971	PowerPoint	1	08-19-2010 07:10 AM
Help with IF statement!	CPelkey	Word	1	04-12-2010 09:06 AM
Syntax help needed	blazzercat	Excel	3	07-09-2009 02:15 PM