Vantage - Dashboard Filters

Yahoo Archive
1
Thanks.




________________________________
From: Lynn <lynn.khalife@...>
To: vantage@yahoogroups.com
Sent: Tuesday, January 27, 2009 2:16:47 PM
Subject: [Vantage] Re: Vantage - Dashboard Filters


I've made some minor changes to BAQs, and the change was automatic on
my Dashboard without me having to re-import. Other times, I wasn't
sure if it would work since my BAQ change seemed major, so I did re-
add the BAQ to my dashboard.

I don't remember having to re-create filters.

I recommend you first try to re-open the dashboard without re-
importing the BAQ & see if it picked up the new field.

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> Hi Lynn,
>
> I've found the solution (well somebody has told me it).
>
> Create calculated field for
>
> If ShipDtl.PackNum >= 0 then 1 else 0
>
> Then filter on the 1 / 0s.
>
> If I import a BAQ into a Dashboard, then make an alteration to the
BAQ (ie add another field) can I re-import the BAQ into the Dashboard
without losing the filters etc I have in place?
>
> Cheers,
>
>
> CHRIS
>
>
>
>
> ____________ _________ _________ __
> From: Lynn <lynn.khalife@ ...>
> To: vantage@yahoogroups .com
> Sent: Tuesday, January 27, 2009 2:05:42 PM
> Subject: [Vantage] Re: Vantage - Dashboard Filters
>
>
> Try PackNum < 1.
>
> If that doesn't work, then I'm out of suggestions, sorry.
>
> Lynn
>
> --- In vantage@yahoogroups .com, Chris Thompson
<chriselectrix@ ...>
> wrote:
> >
> > Hi Lynn,
> >
> > My PackNum column is completely empty - whereas when my Number
> fields are emtpy they show as 0.00000.
> >
> > If I filter on PackNum = 0, it returns no results as I think it
is
> looking for a PackNum called 0, when it isn't actually called '0',
it
> is acutally ' ' (blank).
> >
> > If I try PackNum = 260 it will display the line for PackNum 260,
so
> the functionality is working but 0 doesn't work to retrieve all of
> the 'blank' PackNums.
> >
> > Do you have any further suggestions?
> >
> > I'm really stuck on this one!!
> >
> > Cheers,
> >
> >
> > CHRIS
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Lynn <lynn.khalife@ ...>
> > To: vantage@yahoogroups .com
> > Sent: Tuesday, January 27, 2009 1:20:39 PM
> > Subject: [Vantage] Re: Vantage - Dashboard Filters
> >
> >
> > That is correct, you can't use Null with numeric fields because
the
> > numeric field is never empty. It always has either a zero or a
non-
> > zero number in it.
> >
> > What you really want is PackNum = 0.
> >
> > To the database, 0 is the same as 0.00000.
> >
> > Lynn
> >
> > --- In vantage@yahoogroups .com, Chris Thompson
> <chriselectrix@ ...>
> > wrote:
> > >
> > > Hi,
> > >
> > > I am trying to display all orders on Vantage that do not have a
> > Pack Number (i.e. packing has not started).
> > >
> > > I have a BAQ where I can view the following tables:
> > >
> > > OrderHed
> > > OrderDtl
> > > Customer
> > > ShipDtl
> > >
> > > The only information I need to see is the Request Date, Order
> > Number, PackNum, Customer.
> > >
> > > I have imported the BAQ into a dashboard and have tried to
filter
> > the PackNum field..
> > >
> > > I want to only see the Orders where they don't have a PackNum.
> > >
> > > In other word where PackNum = Null.
> > >
> > > Apparently I can't use a null value with the numeric..
> > >
> > > Epicor suggested comparing it against a Num01 field, but they
> > display as 0.0000 which isn't actually Null.
> > >
> > > Does anyone have any suggestions where I can filter the above
> > information based on the Order NOT having a PackNum?
> > >
> > > Cheers,
> > >
> > >
> > > CHRIS
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
2
Hi,

I am trying to display all orders on Vantage that do not have a Pack Number (i.e. packing has not started).

I have a BAQ where I can view the following tables:

OrderHed
OrderDtl
Customer
ShipDtl

The only information I need to see is the Request Date, Order Number, PackNum, Customer.

I have imported the BAQ into a dashboard and have tried to filter the PackNum field.

I want to only see the Orders where they don't have a PackNum.

In other word where PackNum = Null.

Apparently I can't use a null value with the numeric.

Epicor suggested comparing it against a Num01 field, but they display as 0.0000 which isn't actually Null.

Does anyone have any suggestions where I can filter the above information based on the Order NOT having a PackNum?

Cheers,


CHRIS




[Non-text portions of this message have been removed]
3
That is correct, you can't use Null with numeric fields because the
numeric field is never empty. It always has either a zero or a non-
zero number in it.

What you really want is PackNum = 0.

To the database, 0 is the same as 0.00000.

Lynn




--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...>
wrote:
>
> Hi,
>
> I am trying to display all orders on Vantage that do not have a
Pack Number (i.e. packing has not started).
>
> I have a BAQ where I can view the following tables:
>
> OrderHed
> OrderDtl
> Customer
> ShipDtl
>
> The only information I need to see is the Request Date, Order
Number, PackNum, Customer.
>
> I have imported the BAQ into a dashboard and have tried to filter
the PackNum field.
>
> I want to only see the Orders where they don't have a PackNum.
>
> In other word where PackNum = Null.
>
> Apparently I can't use a null value with the numeric.
>
> Epicor suggested comparing it against a Num01 field, but they
display as 0.0000 which isn't actually Null.
>
> Does anyone have any suggestions where I can filter the above
information based on the Order NOT having a PackNum?
>
> Cheers,
>
>
> CHRIS
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Hi Lynn,

My PackNum column is completely empty - whereas when my Number fields are emtpy they show as 0.00000.

If I filter on PackNum = 0, it returns no results as I think it is looking for a PackNum called 0, when it isn't actually called '0', it is acutally ' ' (blank).

If I try PackNum = 260 it will display the line for PackNum 260, so the functionality is working but 0 doesn't work to retrieve all of the 'blank' PackNums.

Do you have any further suggestions?

I'm really stuck on this one!!

Cheers,


CHRIS




________________________________
From: Lynn <lynn.khalife@...>
To: vantage@yahoogroups.com
Sent: Tuesday, January 27, 2009 1:20:39 PM
Subject: [Vantage] Re: Vantage - Dashboard Filters


That is correct, you can't use Null with numeric fields because the
numeric field is never empty. It always has either a zero or a non-
zero number in it.

What you really want is PackNum = 0.

To the database, 0 is the same as 0.00000.

Lynn

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> Hi,
>
> I am trying to display all orders on Vantage that do not have a
Pack Number (i.e. packing has not started).
>
> I have a BAQ where I can view the following tables:
>
> OrderHed
> OrderDtl
> Customer
> ShipDtl
>
> The only information I need to see is the Request Date, Order
Number, PackNum, Customer.
>
> I have imported the BAQ into a dashboard and have tried to filter
the PackNum field..
>
> I want to only see the Orders where they don't have a PackNum.
>
> In other word where PackNum = Null.
>
> Apparently I can't use a null value with the numeric.
>
> Epicor suggested comparing it against a Num01 field, but they
display as 0.0000 which isn't actually Null.
>
> Does anyone have any suggestions where I can filter the above
information based on the Order NOT having a PackNum?
>
> Cheers,
>
>
> CHRIS
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
5
Create a logic calculation field and do an if that PackNum is Greater than
or equal to 0 then 1 else 0. You can now use this to filter by.

Steve

-----Original Message-----
From: Chris Thompson [mailto:chriselectrix@...]
Sent: January 27, 2009 7:30 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Vantage - Dashboard Filters



Hi Lynn,

My PackNum column is completely empty - whereas when my Number fields are
emtpy they show as 0.00000.

If I filter on PackNum = 0, it returns no results as I think it is looking
for a PackNum called 0, when it isn't actually called '0', it is acutally '
' (blank).

If I try PackNum = 260 it will display the line for PackNum 260, so the
functionality is working but 0 doesn't work to retrieve all of the 'blank'
PackNums.

Do you have any further suggestions?

I'm really stuck on this one!!

Cheers,

CHRIS

________________________________
From: Lynn <lynn.khalife@ <mailto:lynn.khalife%40core-mfg.com> core-mfg.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tuesday, January 27, 2009 1:20:39 PM
Subject: [Vantage] Re: Vantage - Dashboard Filters

That is correct, you can't use Null with numeric fields because the
numeric field is never empty. It always has either a zero or a non-
zero number in it.

What you really want is PackNum = 0.

To the database, 0 is the same as 0.00000.

Lynn

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> Hi,
>
> I am trying to display all orders on Vantage that do not have a
Pack Number (i.e. packing has not started).
>
> I have a BAQ where I can view the following tables:
>
> OrderHed
> OrderDtl
> Customer
> ShipDtl
>
> The only information I need to see is the Request Date, Order
Number, PackNum, Customer.
>
> I have imported the BAQ into a dashboard and have tried to filter
the PackNum field..
>
> I want to only see the Orders where they don't have a PackNum.
>
> In other word where PackNum = Null.
>
> Apparently I can't use a null value with the numeric.
>
> Epicor suggested comparing it against a Num01 field, but they
display as 0.0000 which isn't actually Null.
>
> Does anyone have any suggestions where I can filter the above
information based on the Order NOT having a PackNum?
>
> Cheers,
>
>
> CHRIS
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
6
Hi Steve,

That's great.

Looks like it will work.

Thanks.

Chris




________________________________
From: vantage <vantage@...>
To: vantage@yahoogroups.com
Sent: Tuesday, January 27, 2009 1:34:33 PM
Subject: RE: [Vantage] Re: Vantage - Dashboard Filters


Create a logic calculation field and do an if that PackNum is Greater than
or equal to 0 then 1 else 0. You can now use this to filter by.

Steve

-----Original Message-----
From: Chris Thompson [mailto:chriselectrix@ ymail.com]
Sent: January 27, 2009 7:30 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Re: Vantage - Dashboard Filters

Hi Lynn,

My PackNum column is completely empty - whereas when my Number fields are
emtpy they show as 0.00000.

If I filter on PackNum = 0, it returns no results as I think it is looking
for a PackNum called 0, when it isn't actually called '0', it is acutally '
' (blank).

If I try PackNum = 260 it will display the line for PackNum 260, so the
functionality is working but 0 doesn't work to retrieve all of the 'blank'
PackNums.

Do you have any further suggestions?

I'm really stuck on this one!!

Cheers,

CHRIS

____________ _________ _________ __
From: Lynn <lynn.khalife@ <mailto:lynn. khalife%40core- mfg.com> core-mfg.com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, January 27, 2009 1:20:39 PM
Subject: [Vantage] Re: Vantage - Dashboard Filters

That is correct, you can't use Null with numeric fields because the
numeric field is never empty. It always has either a zero or a non-
zero number in it.

What you really want is PackNum = 0.

To the database, 0 is the same as 0.00000.

Lynn

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> Hi,
>
> I am trying to display all orders on Vantage that do not have a
Pack Number (i.e. packing has not started).
>
> I have a BAQ where I can view the following tables:
>
> OrderHed
> OrderDtl
> Customer
> ShipDtl
>
> The only information I need to see is the Request Date, Order
Number, PackNum, Customer.
>
> I have imported the BAQ into a dashboard and have tried to filter
the PackNum field..
>
> I want to only see the Orders where they don't have a PackNum..
>
> In other word where PackNum = Null.
>
> Apparently I can't use a null value with the numeric.
>
> Epicor suggested comparing it against a Num01 field, but they
display as 0.0000 which isn't actually Null.
>
> Does anyone have any suggestions where I can filter the above
information based on the Order NOT having a PackNum?
>
> Cheers,
>
>
> CHRIS
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
7
Actually I think the problem here is that you need to do an outer join
between OrderDtl and ShipDtl.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Tuesday, January 27, 2009 8:30 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Vantage - Dashboard Filters



Hi Lynn,

My PackNum column is completely empty - whereas when my Number fields
are emtpy they show as 0.00000.

If I filter on PackNum = 0, it returns no results as I think it is
looking for a PackNum called 0, when it isn't actually called '0', it is
acutally ' ' (blank).

If I try PackNum = 260 it will display the line for PackNum 260, so the
functionality is working but 0 doesn't work to retrieve all of the
'blank' PackNums.

Do you have any further suggestions?

I'm really stuck on this one!!

Cheers,

CHRIS

________________________________
From: Lynn <lynn.khalife@...
<mailto:lynn.khalife%40core-mfg.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tuesday, January 27, 2009 1:20:39 PM
Subject: [Vantage] Re: Vantage - Dashboard Filters

That is correct, you can't use Null with numeric fields because the
numeric field is never empty. It always has either a zero or a non-
zero number in it.

What you really want is PackNum = 0.

To the database, 0 is the same as 0.00000.

Lynn

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> Hi,
>
> I am trying to display all orders on Vantage that do not have a
Pack Number (i.e. packing has not started).
>
> I have a BAQ where I can view the following tables:
>
> OrderHed
> OrderDtl
> Customer
> ShipDtl
>
> The only information I need to see is the Request Date, Order
Number, PackNum, Customer.
>
> I have imported the BAQ into a dashboard and have tried to filter
the PackNum field..
>
> I want to only see the Orders where they don't have a PackNum.
>
> In other word where PackNum = Null.
>
> Apparently I can't use a null value with the numeric.
>
> Epicor suggested comparing it against a Num01 field, but they
display as 0.0000 which isn't actually Null.
>
> Does anyone have any suggestions where I can filter the above
information based on the Order NOT having a PackNum?
>
> Cheers,
>
>
> CHRIS
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
8
Try PackNum < 1.

If that doesn't work, then I'm out of suggestions, sorry.

Lynn



--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...>
wrote:
>
> Hi Lynn,
>
> My PackNum column is completely empty - whereas when my Number
fields are emtpy they show as 0.00000.
>
> If I filter on PackNum = 0, it returns no results as I think it is
looking for a PackNum called 0, when it isn't actually called '0', it
is acutally ' ' (blank).
>
> If I try PackNum = 260 it will display the line for PackNum 260, so
the functionality is working but 0 doesn't work to retrieve all of
the 'blank' PackNums.
>
> Do you have any further suggestions?
>
> I'm really stuck on this one!!
>
> Cheers,
>
>
> CHRIS
>
>
>
>
> ________________________________
> From: Lynn <lynn.khalife@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, January 27, 2009 1:20:39 PM
> Subject: [Vantage] Re: Vantage - Dashboard Filters
>
>
> That is correct, you can't use Null with numeric fields because the
> numeric field is never empty. It always has either a zero or a non-
> zero number in it.
>
> What you really want is PackNum = 0.
>
> To the database, 0 is the same as 0.00000.
>
> Lynn
>
> --- In vantage@yahoogroups .com, Chris Thompson
<chriselectrix@ ...>
> wrote:
> >
> > Hi,
> >
> > I am trying to display all orders on Vantage that do not have a
> Pack Number (i.e. packing has not started).
> >
> > I have a BAQ where I can view the following tables:
> >
> > OrderHed
> > OrderDtl
> > Customer
> > ShipDtl
> >
> > The only information I need to see is the Request Date, Order
> Number, PackNum, Customer.
> >
> > I have imported the BAQ into a dashboard and have tried to filter
> the PackNum field..
> >
> > I want to only see the Orders where they don't have a PackNum.
> >
> > In other word where PackNum = Null.
> >
> > Apparently I can't use a null value with the numeric.
> >
> > Epicor suggested comparing it against a Num01 field, but they
> display as 0.0000 which isn't actually Null.
> >
> > Does anyone have any suggestions where I can filter the above
> information based on the Order NOT having a PackNum?
> >
> > Cheers,
> >
> >
> > CHRIS
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
9
Hi Lynn,

I've found the solution (well somebody has told me it).

Create calculated field for

If ShipDtl.PackNum >= 0 then 1 else 0

Then filter on the 1 / 0s.

If I import a BAQ into a Dashboard, then make an alteration to the BAQ (ie add another field) can I re-import the BAQ into the Dashboard without losing the filters etc I have in place?

Cheers,


CHRIS




________________________________
From: Lynn <lynn.khalife@...>
To: vantage@yahoogroups.com
Sent: Tuesday, January 27, 2009 2:05:42 PM
Subject: [Vantage] Re: Vantage - Dashboard Filters


Try PackNum < 1.

If that doesn't work, then I'm out of suggestions, sorry.

Lynn

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> Hi Lynn,
>
> My PackNum column is completely empty - whereas when my Number
fields are emtpy they show as 0.00000.
>
> If I filter on PackNum = 0, it returns no results as I think it is
looking for a PackNum called 0, when it isn't actually called '0', it
is acutally ' ' (blank).
>
> If I try PackNum = 260 it will display the line for PackNum 260, so
the functionality is working but 0 doesn't work to retrieve all of
the 'blank' PackNums.
>
> Do you have any further suggestions?
>
> I'm really stuck on this one!!
>
> Cheers,
>
>
> CHRIS
>
>
>
>
> ____________ _________ _________ __
> From: Lynn <lynn.khalife@ ...>
> To: vantage@yahoogroups .com
> Sent: Tuesday, January 27, 2009 1:20:39 PM
> Subject: [Vantage] Re: Vantage - Dashboard Filters
>
>
> That is correct, you can't use Null with numeric fields because the
> numeric field is never empty. It always has either a zero or a non-
> zero number in it.
>
> What you really want is PackNum = 0.
>
> To the database, 0 is the same as 0.00000.
>
> Lynn
>
> --- In vantage@yahoogroups .com, Chris Thompson
<chriselectrix@ ...>
> wrote:
> >
> > Hi,
> >
> > I am trying to display all orders on Vantage that do not have a
> Pack Number (i.e. packing has not started).
> >
> > I have a BAQ where I can view the following tables:
> >
> > OrderHed
> > OrderDtl
> > Customer
> > ShipDtl
> >
> > The only information I need to see is the Request Date, Order
> Number, PackNum, Customer.
> >
> > I have imported the BAQ into a dashboard and have tried to filter
> the PackNum field..
> >
> > I want to only see the Orders where they don't have a PackNum.
> >
> > In other word where PackNum = Null.
> >
> > Apparently I can't use a null value with the numeric.
> >
> > Epicor suggested comparing it against a Num01 field, but they
> display as 0.0000 which isn't actually Null.
> >
> > Does anyone have any suggestions where I can filter the above
> information based on the Order NOT having a PackNum?
> >
> > Cheers,
> >
> >
> > CHRIS
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
10
I've made some minor changes to BAQs, and the change was automatic on
my Dashboard without me having to re-import. Other times, I wasn't
sure if it would work since my BAQ change seemed major, so I did re-
add the BAQ to my dashboard.

I don't remember having to re-create filters.

I recommend you first try to re-open the dashboard without re-
importing the BAQ & see if it picked up the new field.


--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...>
wrote:
>
> Hi Lynn,
>
> I've found the solution (well somebody has told me it).
>
> Create calculated field for
>
> If ShipDtl.PackNum >= 0 then 1 else 0
>
> Then filter on the 1 / 0s.
>
> If I import a BAQ into a Dashboard, then make an alteration to the
BAQ (ie add another field) can I re-import the BAQ into the Dashboard
without losing the filters etc I have in place?
>
> Cheers,
>
>
> CHRIS
>
>
>
>
> ________________________________
> From: Lynn <lynn.khalife@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, January 27, 2009 2:05:42 PM
> Subject: [Vantage] Re: Vantage - Dashboard Filters
>
>
> Try PackNum < 1.
>
> If that doesn't work, then I'm out of suggestions, sorry.
>
> Lynn
>
> --- In vantage@yahoogroups .com, Chris Thompson
<chriselectrix@ ...>
> wrote:
> >
> > Hi Lynn,
> >
> > My PackNum column is completely empty - whereas when my Number
> fields are emtpy they show as 0.00000.
> >
> > If I filter on PackNum = 0, it returns no results as I think it
is
> looking for a PackNum called 0, when it isn't actually called '0',
it
> is acutally ' ' (blank).
> >
> > If I try PackNum = 260 it will display the line for PackNum 260,
so
> the functionality is working but 0 doesn't work to retrieve all of
> the 'blank' PackNums.
> >
> > Do you have any further suggestions?
> >
> > I'm really stuck on this one!!
> >
> > Cheers,
> >
> >
> > CHRIS
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Lynn <lynn.khalife@ ...>
> > To: vantage@yahoogroups .com
> > Sent: Tuesday, January 27, 2009 1:20:39 PM
> > Subject: [Vantage] Re: Vantage - Dashboard Filters
> >
> >
> > That is correct, you can't use Null with numeric fields because
the
> > numeric field is never empty. It always has either a zero or a
non-
> > zero number in it.
> >
> > What you really want is PackNum = 0.
> >
> > To the database, 0 is the same as 0.00000.
> >
> > Lynn
> >
> > --- In vantage@yahoogroups .com, Chris Thompson
> <chriselectrix@ ...>
> > wrote:
> > >
> > > Hi,
> > >
> > > I am trying to display all orders on Vantage that do not have a
> > Pack Number (i.e. packing has not started).
> > >
> > > I have a BAQ where I can view the following tables:
> > >
> > > OrderHed
> > > OrderDtl
> > > Customer
> > > ShipDtl
> > >
> > > The only information I need to see is the Request Date, Order
> > Number, PackNum, Customer.
> > >
> > > I have imported the BAQ into a dashboard and have tried to
filter
> > the PackNum field..
> > >
> > > I want to only see the Orders where they don't have a PackNum.
> > >
> > > In other word where PackNum = Null.
> > >
> > > Apparently I can't use a null value with the numeric.
> > >
> > > Epicor suggested comparing it against a Num01 field, but they
> > display as 0.0000 which isn't actually Null.
> > >
> > > Does anyone have any suggestions where I can filter the above
> > information based on the Order NOT having a PackNum?
> > >
> > > Cheers,
> > >
> > >
> > > CHRIS
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>