Does this function exist?

Corrected version:

dim recselected as boolean
dim showsearch as boolean = true
dim whereclause as string = "Key4 = '" & txtepicustom11.text &"'"
dim multirecords as boolean = true
dim i as integer
dim max as double
dim parameter as string

'// "your searchadapter" multiselect shoud be true and the "showsearch"
must be false ( i don't know what happens if you select something)

if recselected
i =1
max = 0
while i <= dsSearch.Tables(0).Rows.count()-1
if max < dsSearch.Tables(0).Rows(i)("key5")
max = dsSearch.Tables(0).Rows(i)("key5")
end if
i = i + 1
end while
else
max = 1
end if
'// for feedback
parameter = max
MessageBox.Show(parameter, "Value", MessageBoxButtons.OK,
MessageBoxIcon.Error)


>
> I can't get it to work but how about this?
> ---------------------------------------
> dim recselected as boolean
> dim showsearch as boolean = true
> dim whereclause as string = "Key4 = '" & txtepicustom11.text &"'"
> dim multirecords as boolean = true
> dim i as integer
> dim max as double
>
> "your searchadapter"
> if recselected
> i =0
> max = 0
> while i <= dsSearch.Tables(0).Rows.count()
> if max > dsSearch.Tables(0).Rows(i)("key5")
> max = dsSearch.Tables(0).Rows(i)("key5")
> end if
> i = i + 1
> end while
> else
> max = 1
> end if
>
> ----------------------------------------------
> max is the maximum value of key 5
>
>
> Matt Barron schreef:
>> numeric
>>
>> ________________________________
>>
>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
>> Of Fons van der Beek
>> Sent: Monday, August 27, 2007 11:48 AM
>> To: vantage@yahoogroups.com
>> Subject: Re: [Vantage] Re: Does this function exist?
>>
>>
>>
>> is key5 a numeric field of a textfield?
>>
>> Matt Barron schreef:
>>
>>> Ok - here are my variable declarations before I call the search
>>> function. I already want the list to be filtered by what is in Key4
>>> already on the form.
>>>
>>> dim recselected as boolean
>>> dim showsearch as boolean = true
>>> dim whereclause as string = "Key4 = '" & txtepicustom11.text &
>>> "'"
>>> dim multirecords as boolean = true
>>>
>>> If I want it to sort by Key5 and have it sort by the highest value in
>>> that column, would it look like "dim whereclause as string = BY key5"
>>>
>> ?
>>
>>> In addition, is there a way I can have it search by both what is in
>>>
>> Key4
>>
>>> (as shown above) and this new function that youre talking about?
>>>
>>> Matt
>>>
>>>
>>>
>>> ________________________________
>>>
>>> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>>
>> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
>> Behalf
>>
>>> Of bw2868bond
>>> Sent: Monday, August 27, 2007 11:05 AM
>>> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>> Subject: [Vantage] Re: Does this function exist?
>>>
>>>
>>>
>>> The BY keyword in a where clause orders the data returned like the
>>> SQL OrderBy, The only issue is I don't think it works on all fields.
>>> You can try it and see.
>>>
>>> bw
>>>
>>> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>>
>> <mailto:vantage%40yahoogroups.com> ,
>>
>>> "Matt Barron" <mbarron@...> wrote:
>>>
>>>
>>>> If the dataset can be sorted after filled, that would be awesome.
>>>>
>>>>
>>> That
>>>
>>>
>>>> would make everything so much easier.
>>>>
>>>> What is a "BY" keyword?
>>>>
>>>> If either the dataset can be sorted or if the whereclause can be
>>>>
>>>>
>>> set to
>>>
>>>
>>>> the max value - this would be a piece of cake...
>>>>
>>>> Anyone know if that is possible?
>>>>
>>>> ________________________________
>>>>
>>>> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>>>
>> <mailto:vantage%40yahoogroups.com>
>>
>>> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>>
>> <mailto:vantage%40yahoogroups.com> ] On
>>
>>> Behalf
>>>
>>>
>>>> Of bw2868bond
>>>> Sent: Monday, August 27, 2007 10:51 AM
>>>> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>>>
>> <mailto:vantage%40yahoogroups.com>
>>
>>>> Subject: [Vantage] Re: Does this function exist?
>>>>
>>>>
>>>>
>>>> A couple random thoughts....
>>>>
>>>> Can the dataset be sorted after filled?
>>>> Can the whereclause Use the BY keyword to sort the data and then
>>>> select first row?
>>>> Can the whereclause select only Max value?
>>>>
>>>> bw
>>>>
>>>> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>>>
>> <mailto:vantage%40yahoogroups.com>
>>
>>> <mailto:vantage%40yahoogroups.com> ,
>>>
>>>
>>>> "dub554" <mbarron@> wrote:
>>>>
>>>>
>>>>> Is there a VB function that will automatically find the highest
>>>>>
>>>>>
>>>> value
>>>>
>>>>
>>>>> in a particular column after a searchfunction.listlookup function
>>>>>
>>>>>
>>> is
>>>
>>>
>>>>> called?
>>>>>
>>>>> I'd like to be able to find the highest value of this column in
>>>>>
>>>>>
>>> the
>>>
>>>
>>>>> search....
>>>>>
>>>>> Thanks for any input
>>>>>
>>>>>
>>>>>
>>>>
>>>> [Non-text portions of this message have been removed]
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> [Non-text portions of this message have been removed]
>>>
>>>
>>>
>>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
>>>
>> have already linked your email address to a yahoo id to enable access. )
>>
>>> (1) To access the Files Section of our Yahoo!Group for Report Builder
>>>
>> and Crystal Reports and other 'goodies', please goto:
>> http://groups.yahoo.com/group/vantage/files/.
>> <http://groups.yahoo.com/group/vantage/files/.>
>>
>>> (2) To search through old msg's goto:
>>>
>> http://groups.yahoo.com/group/vantage/messages
>> <http://groups.yahoo.com/group/vantage/messages>
>>
>>> (3) To view links to Vendors that provide Vantage services goto:
>>>
>> http://groups.yahoo.com/group/vantage/links
>> <http://groups.yahoo.com/group/vantage/links>
>>
>>> Yahoo! Groups Links
>>>
>>>
>>>
>>>
>>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
>> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
>> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
>> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
>> Yahoo! Groups Links
>>
>>
>>
>>
>



[Non-text portions of this message have been removed]
Is there a VB function that will automatically find the highest value
in a particular column after a searchfunction.listlookup function is
called?

I'd like to be able to find the highest value of this column in the
search....

Thanks for any input
A couple random thoughts....

Can the dataset be sorted after filled?
Can the whereclause Use the BY keyword to sort the data and then
select first row?
Can the whereclause select only Max value?

bw


--- In vantage@yahoogroups.com, "dub554" <mbarron@...> wrote:
>
>
> Is there a VB function that will automatically find the highest
value
> in a particular column after a searchfunction.listlookup function is
> called?
>
> I'd like to be able to find the highest value of this column in the
> search....
>
> Thanks for any input
>
If the dataset can be sorted after filled, that would be awesome. That
would make everything so much easier.

What is a "BY" keyword?

If either the dataset can be sorted or if the whereclause can be set to
the max value - this would be a piece of cake...

Anyone know if that is possible?

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: Monday, August 27, 2007 10:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Does this function exist?



A couple random thoughts....

Can the dataset be sorted after filled?
Can the whereclause Use the BY keyword to sort the data and then
select first row?
Can the whereclause select only Max value?

bw

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"dub554" <mbarron@...> wrote:
>
>
> Is there a VB function that will automatically find the highest
value
> in a particular column after a searchfunction.listlookup function is
> called?
>
> I'd like to be able to find the highest value of this column in the
> search....
>
> Thanks for any input
>






[Non-text portions of this message have been removed]
The BY keyword in a where clause orders the data returned like the
SQL OrderBy, The only issue is I don't think it works on all fields.
You can try it and see.

bw


--- In vantage@yahoogroups.com, "Matt Barron" <mbarron@...> wrote:
>
> If the dataset can be sorted after filled, that would be awesome.
That
> would make everything so much easier.
>
> What is a "BY" keyword?
>
> If either the dataset can be sorted or if the whereclause can be
set to
> the max value - this would be a piece of cake...
>
> Anyone know if that is possible?
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of bw2868bond
> Sent: Monday, August 27, 2007 10:51 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Does this function exist?
>
>
>
> A couple random thoughts....
>
> Can the dataset be sorted after filled?
> Can the whereclause Use the BY keyword to sort the data and then
> select first row?
> Can the whereclause select only Max value?
>
> bw
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "dub554" <mbarron@> wrote:
> >
> >
> > Is there a VB function that will automatically find the highest
> value
> > in a particular column after a searchfunction.listlookup function
is
> > called?
> >
> > I'd like to be able to find the highest value of this column in
the
> > search....
> >
> > Thanks for any input
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Ok - here are my variable declarations before I call the search
function. I already want the list to be filtered by what is in Key4
already on the form.

dim recselected as boolean
dim showsearch as boolean = true
dim whereclause as string = "Key4 = '" & txtepicustom11.text &
"'"
dim multirecords as boolean = true

If I want it to sort by Key5 and have it sort by the highest value in
that column, would it look like "dim whereclause as string = BY key5" ?

In addition, is there a way I can have it search by both what is in Key4
(as shown above) and this new function that youre talking about?

Matt



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: Monday, August 27, 2007 11:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Does this function exist?



The BY keyword in a where clause orders the data returned like the
SQL OrderBy, The only issue is I don't think it works on all fields.
You can try it and see.

bw

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Matt Barron" <mbarron@...> wrote:
>
> If the dataset can be sorted after filled, that would be awesome.
That
> would make everything so much easier.
>
> What is a "BY" keyword?
>
> If either the dataset can be sorted or if the whereclause can be
set to
> the max value - this would be a piece of cake...
>
> Anyone know if that is possible?
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of bw2868bond
> Sent: Monday, August 27, 2007 10:51 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Does this function exist?
>
>
>
> A couple random thoughts....
>
> Can the dataset be sorted after filled?
> Can the whereclause Use the BY keyword to sort the data and then
> select first row?
> Can the whereclause select only Max value?
>
> bw
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "dub554" <mbarron@> wrote:
> >
> >
> > Is there a VB function that will automatically find the highest
> value
> > in a particular column after a searchfunction.listlookup function
is
> > called?
> >
> > I'd like to be able to find the highest value of this column in
the
> > search....
> >
> > Thanks for any input
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
is key5 a numeric field of a textfield?

Matt Barron schreef:
> Ok - here are my variable declarations before I call the search
> function. I already want the list to be filtered by what is in Key4
> already on the form.
>
> dim recselected as boolean
> dim showsearch as boolean = true
> dim whereclause as string = "Key4 = '" & txtepicustom11.text &
> "'"
> dim multirecords as boolean = true
>
> If I want it to sort by Key5 and have it sort by the highest value in
> that column, would it look like "dim whereclause as string = BY key5" ?
>
> In addition, is there a way I can have it search by both what is in Key4
> (as shown above) and this new function that youre talking about?
>
> Matt
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of bw2868bond
> Sent: Monday, August 27, 2007 11:05 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Does this function exist?
>
>
>
> The BY keyword in a where clause orders the data returned like the
> SQL OrderBy, The only issue is I don't think it works on all fields.
> You can try it and see.
>
> bw
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Matt Barron" <mbarron@...> wrote:
>
>> If the dataset can be sorted after filled, that would be awesome.
>>
> That
>
>> would make everything so much easier.
>>
>> What is a "BY" keyword?
>>
>> If either the dataset can be sorted or if the whereclause can be
>>
> set to
>
>> the max value - this would be a piece of cake...
>>
>> Anyone know if that is possible?
>>
>> ________________________________
>>
>> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
>
>> Of bw2868bond
>> Sent: Monday, August 27, 2007 10:51 AM
>> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>> Subject: [Vantage] Re: Does this function exist?
>>
>>
>>
>> A couple random thoughts....
>>
>> Can the dataset be sorted after filled?
>> Can the whereclause Use the BY keyword to sort the data and then
>> select first row?
>> Can the whereclause select only Max value?
>>
>> bw
>>
>> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>
> <mailto:vantage%40yahoogroups.com> ,
>
>> "dub554" <mbarron@> wrote:
>>
>>> Is there a VB function that will automatically find the highest
>>>
>> value
>>
>>> in a particular column after a searchfunction.listlookup function
>>>
> is
>
>>> called?
>>>
>>> I'd like to be able to find the highest value of this column in
>>>
> the
>
>>> search....
>>>
>>> Thanks for any input
>>>
>>>
>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>



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

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Fons van der Beek
Sent: Monday, August 27, 2007 11:48 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Does this function exist?



is key5 a numeric field of a textfield?

Matt Barron schreef:
> Ok - here are my variable declarations before I call the search
> function. I already want the list to be filtered by what is in Key4
> already on the form.
>
> dim recselected as boolean
> dim showsearch as boolean = true
> dim whereclause as string = "Key4 = '" & txtepicustom11.text &
> "'"
> dim multirecords as boolean = true
>
> If I want it to sort by Key5 and have it sort by the highest value in
> that column, would it look like "dim whereclause as string = BY key5"
?
>
> In addition, is there a way I can have it search by both what is in
Key4
> (as shown above) and this new function that youre talking about?
>
> Matt
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of bw2868bond
> Sent: Monday, August 27, 2007 11:05 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Does this function exist?
>
>
>
> The BY keyword in a where clause orders the data returned like the
> SQL OrderBy, The only issue is I don't think it works on all fields.
> You can try it and see.
>
> bw
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Matt Barron" <mbarron@...> wrote:
>
>> If the dataset can be sorted after filled, that would be awesome.
>>
> That
>
>> would make everything so much easier.
>>
>> What is a "BY" keyword?
>>
>> If either the dataset can be sorted or if the whereclause can be
>>
> set to
>
>> the max value - this would be a piece of cake...
>>
>> Anyone know if that is possible?
>>
>> ________________________________
>>
>> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
>>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf
>
>> Of bw2868bond
>> Sent: Monday, August 27, 2007 10:51 AM
>> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
>> Subject: [Vantage] Re: Does this function exist?
>>
>>
>>
>> A couple random thoughts....
>>
>> Can the dataset be sorted after filled?
>> Can the whereclause Use the BY keyword to sort the data and then
>> select first row?
>> Can the whereclause select only Max value?
>>
>> bw
>>
>> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
>>
> <mailto:vantage%40yahoogroups.com> ,
>
>> "dub554" <mbarron@> wrote:
>>
>>> Is there a VB function that will automatically find the highest
>>>
>> value
>>
>>> in a particular column after a searchfunction.listlookup function
>>>
> is
>
>>> called?
>>>
>>> I'd like to be able to find the highest value of this column in
>>>
> the
>
>>> search....
>>>
>>> Thanks for any input
>>>
>>>
>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
> Yahoo! Groups Links
>
>
>
>

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






[Non-text portions of this message have been removed]
I can't get it to work but how about this?
---------------------------------------

dim recselected as boolean
dim showsearch as boolean = true
dim whereclause as string = "Key4 = '" & txtepicustom11.text &"'"
dim multirecords as boolean = true
dim i as integer
dim max as double

"your searchadapter"
if recselected
i =0
max = 0
while i <= dsSearch.Tables(0).Rows.count()
if max > dsSearch.Tables(0).Rows(i)("key5")
max = dsSearch.Tables(0).Rows(i)("key5")
end if
i = i + 1
end while
else
max = 1
end if

----------------------------------------------
max is the maximum value of key 5


Matt Barron schreef:
> numeric
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Fons van der Beek
> Sent: Monday, August 27, 2007 11:48 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Re: Does this function exist?
>
>
>
> is key5 a numeric field of a textfield?
>
> Matt Barron schreef:
>
>> Ok - here are my variable declarations before I call the search
>> function. I already want the list to be filtered by what is in Key4
>> already on the form.
>>
>> dim recselected as boolean
>> dim showsearch as boolean = true
>> dim whereclause as string = "Key4 = '" & txtepicustom11.text &
>> "'"
>> dim multirecords as boolean = true
>>
>> If I want it to sort by Key5 and have it sort by the highest value in
>> that column, would it look like "dim whereclause as string = BY key5"
>>
> ?
>
>> In addition, is there a way I can have it search by both what is in
>>
> Key4
>
>> (as shown above) and this new function that youre talking about?
>>
>> Matt
>>
>>
>>
>> ________________________________
>>
>> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
>
>> Of bw2868bond
>> Sent: Monday, August 27, 2007 11:05 AM
>> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>> Subject: [Vantage] Re: Does this function exist?
>>
>>
>>
>> The BY keyword in a where clause orders the data returned like the
>> SQL OrderBy, The only issue is I don't think it works on all fields.
>> You can try it and see.
>>
>> bw
>>
>> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>
> <mailto:vantage%40yahoogroups.com> ,
>
>> "Matt Barron" <mbarron@...> wrote:
>>
>>
>>> If the dataset can be sorted after filled, that would be awesome.
>>>
>>>
>> That
>>
>>
>>> would make everything so much easier.
>>>
>>> What is a "BY" keyword?
>>>
>>> If either the dataset can be sorted or if the whereclause can be
>>>
>>>
>> set to
>>
>>
>>> the max value - this would be a piece of cake...
>>>
>>> Anyone know if that is possible?
>>>
>>> ________________________________
>>>
>>> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>>
> <mailto:vantage%40yahoogroups.com>
>
>> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>
> <mailto:vantage%40yahoogroups.com> ] On
>
>> Behalf
>>
>>
>>> Of bw2868bond
>>> Sent: Monday, August 27, 2007 10:51 AM
>>> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>>
> <mailto:vantage%40yahoogroups.com>
>
>>> Subject: [Vantage] Re: Does this function exist?
>>>
>>>
>>>
>>> A couple random thoughts....
>>>
>>> Can the dataset be sorted after filled?
>>> Can the whereclause Use the BY keyword to sort the data and then
>>> select first row?
>>> Can the whereclause select only Max value?
>>>
>>> bw
>>>
>>> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>>
> <mailto:vantage%40yahoogroups.com>
>
>> <mailto:vantage%40yahoogroups.com> ,
>>
>>
>>> "dub554" <mbarron@> wrote:
>>>
>>>
>>>> Is there a VB function that will automatically find the highest
>>>>
>>>>
>>> value
>>>
>>>
>>>> in a particular column after a searchfunction.listlookup function
>>>>
>>>>
>> is
>>
>>
>>>> called?
>>>>
>>>> I'd like to be able to find the highest value of this column in
>>>>
>>>>
>> the
>>
>>
>>>> search....
>>>>
>>>> Thanks for any input
>>>>
>>>>
>>>>
>>>
>>>
>>> [Non-text portions of this message have been removed]
>>>
>>>
>>>
>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
>>
> have already linked your email address to a yahoo id to enable access. )
>
>> (1) To access the Files Section of our Yahoo!Group for Report Builder
>>
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.>
>
>> (2) To search through old msg's goto:
>>
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
>
>> (3) To view links to Vendors that provide Vantage services goto:
>>
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>



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