Re: [Emerald] printing problems again

Dale E. Reed Jr. ( (no email) )
Sat, 26 Feb 2000 15:32:49 -0800

Kenneth Gustav Eitenmiller Jr wrote:
>
> > > Is there a SQL query that will tell me which of the 40+ invoices
> > > created on that day are the 11 that need to be printed out?
> >
> > The ones "Where SentDate IS NULL"
>
> That comes up with 117 invoices... not 11...

Also take type into consideration. However, in most senses, a NULL
sentdate means it needs to be printed, emailed, Batched out, etc.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart