Problem with Max

  • Thread starter Thread starter Hugh
  • Start date Start date
H

Hugh

Hello,

I am using Access 2000. I have a report with several controls, three of
which are named "Game 1", "Game 2", and "Game 3" that receive their values
from a query that the report is based upon. I have another control named
"Series" that receives the sum of the three game values. Data is entered on
a weekly basis.
Problem:
There is another control named "High Series" that is supposed to receive the
highest value from the "Series" control. "High Series" control source is set
to:
=Max([Text14]), Text14 representing the "Series" control. No value is
returned to "High Series" using this function. Could someone please help,
I'm new at this and not yet familiar with how all these functions are
suppose to work and where?

Hugh
 
You can't use an aggregate on a "control". You can use an aggregate on a
field or expression from the report's record source.
=Max([Your Control Source Property from Text14])
 
Duane,

I don't know if I am doing something wrong or just don't understand
completely but it still is not working. The "control source" for "Series"
reads thusly:
=([Text01]+[Text02]+[Text03]) representing the three games score (Text14).
The "control source" for "High Series" is:
=Max(([Text01]+[Text02]+[Text03])). I tried to force the 'assign' operator
as shown in [Text14} but to no avail and am not sure if it is necessary. Can
you see anything wrong with either of these expr's. Every thing else seems
to work ok except now I get a msg box asking for Text01, 02, & 03 parameter
input. Thank you for your time Duane, you have been very helpful to me.

Hugh

Duane Hookom said:
You can't use an aggregate on a "control". You can use an aggregate on a
field or expression from the report's record source.
=Max([Your Control Source Property from Text14])


--
Duane Hookom
MS Access MVP
--

Hugh said:
Hello,

I am using Access 2000. I have a report with several controls, three of
which are named "Game 1", "Game 2", and "Game 3" that receive their values
from a query that the report is based upon. I have another control named
"Series" that receives the sum of the three game values. Data is entered on
a weekly basis.
Problem:
There is another control named "High Series" that is supposed to receive the
highest value from the "Series" control. "High Series" control source is set
to:
=Max([Text14]), Text14 representing the "Series" control. No value is
returned to "High Series" using this function. Could someone please help,
I'm new at this and not yet familiar with how all these functions are
suppose to work and where?

Hugh
Click to expand...
Click to expand...
 
What are the control sources of Text01, Text02 and Text03? I hope we can
drill down to find a field somewhere.
BTW: Find a nice naming convention. Text03 doesn't say much about what the
control is used for.

--
Duane Hookom
MS Access MVP


Hugh said:
Duane,

I don't know if I am doing something wrong or just don't understand
completely but it still is not working. The "control source" for "Series"
reads thusly:
=([Text01]+[Text02]+[Text03]) representing the three games score (Text14).
The "control source" for "High Series" is:
=Max(([Text01]+[Text02]+[Text03])). I tried to force the 'assign' operator
as shown in [Text14} but to no avail and am not sure if it is necessary. Can
you see anything wrong with either of these expr's. Every thing else seems
to work ok except now I get a msg box asking for Text01, 02, & 03 parameter
input. Thank you for your time Duane, you have been very helpful to me.

Hugh

Duane Hookom said:
You can't use an aggregate on a "control". You can use an aggregate on a
field or expression from the report's record source.
=Max([Your Control Source Property from Text14])


--
Duane Hookom
MS Access MVP
--

Hugh said:
Hello,

I am using Access 2000. I have a report with several controls, three of
which are named "Game 1", "Game 2", and "Game 3" that receive their values
from a query that the report is based upon. I have another control named
"Series" that receives the sum of the three game values. Data is
Click to expand...
entered
on
a weekly basis.
Problem:
There is another control named "High Series" that is supposed to
Click to expand...
receive
the
highest value from the "Series" control. "High Series" control source
Click to expand...
is
set
to:
=Max([Text14]), Text14 representing the "Series" control. No value is
returned to "High Series" using this function. Could someone please help,
I'm new at this and not yet familiar with how all these functions are
suppose to work and where?

Hugh
Click to expand...
Click to expand...
Click to expand...
 
Text01, Text02, and Text03 are the text boxes in the report that receive
their value from "Game 1", "Game 2", and "Game 3" (control source) in the
query that the report is based on.

Hugh

Duane Hookom said:
What are the control sources of Text01, Text02 and Text03? I hope we can
drill down to find a field somewhere.
BTW: Find a nice naming convention. Text03 doesn't say much about what the
control is used for.

--
Duane Hookom
MS Access MVP


Hugh said:
Duane,

I don't know if I am doing something wrong or just don't understand
completely but it still is not working. The "control source" for "Series"
reads thusly:
=([Text01]+[Text02]+[Text03]) representing the three games score (Text14).
The "control source" for "High Series" is:
=Max(([Text01]+[Text02]+[Text03])). I tried to force the 'assign' operator
as shown in [Text14} but to no avail and am not sure if it is necessary. Can
you see anything wrong with either of these expr's. Every thing else seems
to work ok except now I get a msg box asking for Text01, 02, & 03 parameter
input. Thank you for your time Duane, you have been very helpful to me.

Hugh

Duane Hookom said:
You can't use an aggregate on a "control". You can use an aggregate on a
field or expression from the report's record source.
=Max([Your Control Source Property from Text14])


--
Duane Hookom
MS Access MVP
--

Hello,

I am using Access 2000. I have a report with several controls, three of
which are named "Game 1", "Game 2", and "Game 3" that receive their values
from a query that the report is based upon. I have another control named
"Series" that receives the sum of the three game values. Data is entered
on
a weekly basis.
Problem:
There is another control named "High Series" that is supposed to receive
the
highest value from the "Series" control. "High Series" control
Click to expand...
Click to expand...
source
is
set
to:
=Max([Text14]), Text14 representing the "Series" control. No value is
returned to "High Series" using this function. Could someone please help,
I'm new at this and not yet familiar with how all these functions are
suppose to work and where?

Hugh
Click to expand...
Click to expand...
Click to expand...
 
If these are all fields in the record source of the report then you can use:
=Max([Game 1]+[Game 2]+[Game 3])

--
Duane Hookom
MS Access MVP


Hugh said:
Text01, Text02, and Text03 are the text boxes in the report that receive
their value from "Game 1", "Game 2", and "Game 3" (control source) in the
query that the report is based on.

Hugh

Duane Hookom said:
What are the control sources of Text01, Text02 and Text03? I hope we can
drill down to find a field somewhere.
BTW: Find a nice naming convention. Text03 doesn't say much about what the
control is used for.

--
Duane Hookom
MS Access MVP


Hugh said:
Duane,

I don't know if I am doing something wrong or just don't understand
completely but it still is not working. The "control source" for "Series"
reads thusly:
=([Text01]+[Text02]+[Text03]) representing the three games score (Text14).
The "control source" for "High Series" is:
=Max(([Text01]+[Text02]+[Text03])). I tried to force the 'assign' operator
as shown in [Text14} but to no avail and am not sure if it is
Click to expand...
necessary.
Can
you see anything wrong with either of these expr's. Every thing else seems
to work ok except now I get a msg box asking for Text01, 02, & 03 parameter
input. Thank you for your time Duane, you have been very helpful to me.

Hugh

You can't use an aggregate on a "control". You can use an aggregate
Click to expand...
Click to expand...
on
a
field or expression from the report's record source.
=Max([Your Control Source Property from Text14])


--
Duane Hookom
MS Access MVP
--

Hello,

I am using Access 2000. I have a report with several controls,
Click to expand...
three
of
which are named "Game 1", "Game 2", and "Game 3" that receive their
values
from a query that the report is based upon. I have another control named
"Series" that receives the sum of the three game values. Data is entered
on
a weekly basis.
Problem:
There is another control named "High Series" that is supposed to receive
the
highest value from the "Series" control. "High Series" control
Click to expand...
source
is
set
to:
=Max([Text14]), Text14 representing the "Series" control. No value is
returned to "High Series" using this function. Could someone please
help,
I'm new at this and not yet familiar with how all these functions are
suppose to work and where?

Hugh
Click to expand...
Click to expand...
Click to expand...
 
I can't thank you enough Duane, you are a tremendous asset to this group and
to me. You have saved my "bacon" on more than one occasion for which I am
very grateful. One final question (for now), do you know of any books that
would be beneficial to me in helping me to understand the ins and outs of
Access 2000.

Hugh

If these are all fields in
the record source of the report then you can use:
=Max([Game 1]+[Game 2]+[Game 3])

--
Duane Hookom
MS Access MVP


Hugh said:
Text01, Text02, and Text03 are the text boxes in the report that receive
their value from "Game 1", "Game 2", and "Game 3" (control source) in the
query that the report is based on.

Hugh

Duane Hookom said:
What are the control sources of Text01, Text02 and Text03? I hope we can
drill down to find a field somewhere.
BTW: Find a nice naming convention. Text03 doesn't say much about what the
control is used for.

--
Duane Hookom
MS Access MVP


Duane,

I don't know if I am doing something wrong or just don't understand
completely but it still is not working. The "control source" for "Series"
reads thusly:
=([Text01]+[Text02]+[Text03]) representing the three games score (Text14).
The "control source" for "High Series" is:
=Max(([Text01]+[Text02]+[Text03])). I tried to force the 'assign' operator
as shown in [Text14} but to no avail and am not sure if it is necessary.
Can
you see anything wrong with either of these expr's. Every thing else seems
to work ok except now I get a msg box asking for Text01, 02, & 03
parameter
input. Thank you for your time Duane, you have been very helpful to me.

Hugh

You can't use an aggregate on a "control". You can use an
Click to expand...
Click to expand...
aggregate
on
a
field or expression from the report's record source.
=Max([Your Control Source Property from Text14])


--
Duane Hookom
MS Access MVP
--

Hello,

I am using Access 2000. I have a report with several controls, three
of
which are named "Game 1", "Game 2", and "Game 3" that receive their
values
from a query that the report is based upon. I have another control
named
"Series" that receives the sum of the three game values. Data is
entered
on
a weekly basis.
Problem:
There is another control named "High Series" that is supposed to
receive
the
highest value from the "Series" control. "High Series" control source
is
set
to:
=Max([Text14]), Text14 representing the "Series" control. No
Click to expand...
value
is
returned to "High Series" using this function. Could someone please
help,
I'm new at this and not yet familiar with how all these
Click to expand...
functions
are
suppose to work and where?

Hugh
Click to expand...
Click to expand...
Click to expand...
 
Check John Viescas' site www.viescas.com for some recommendations. His
Inside Out book for 2003 is very comprehensive. You may need to go to a
local book store and browse the shelves. I would start by writing down about
10-12 questions and then try to find the answers in the books.

--
Duane Hookom
MS Access MVP
--


Hugh said:
I can't thank you enough Duane, you are a tremendous asset to this group and
to me. You have saved my "bacon" on more than one occasion for which I am
very grateful. One final question (for now), do you know of any books that
would be beneficial to me in helping me to understand the ins and outs of
Access 2000.

Hugh

If these are all fields in
the record source of the report then you can use:
=Max([Game 1]+[Game 2]+[Game 3])

--
Duane Hookom
MS Access MVP


Hugh said:
Text01, Text02, and Text03 are the text boxes in the report that receive
their value from "Game 1", "Game 2", and "Game 3" (control source)
Click to expand...
in
the
query that the report is based on.

Hugh

What are the control sources of Text01, Text02 and Text03? I hope we can
drill down to find a field somewhere.
BTW: Find a nice naming convention. Text03 doesn't say much about
Click to expand...
what
the
control is used for.

--
Duane Hookom
MS Access MVP


Duane,

I don't know if I am doing something wrong or just don't understand
completely but it still is not working. The "control source" for
"Series"
reads thusly:
=([Text01]+[Text02]+[Text03]) representing the three games score
(Text14).
The "control source" for "High Series" is:
=Max(([Text01]+[Text02]+[Text03])). I tried to force the 'assign'
operator
as shown in [Text14} but to no avail and am not sure if it is necessary.
Can
you see anything wrong with either of these expr's. Every thing else
seems
to work ok except now I get a msg box asking for Text01, 02, & 03
parameter
input. Thank you for your time Duane, you have been very helpful
Click to expand...
to
me.
Hugh

You can't use an aggregate on a "control". You can use an
Click to expand...
aggregate
on
a
field or expression from the report's record source.
=Max([Your Control Source Property from Text14])


--
Duane Hookom
MS Access MVP
--

Hello,

I am using Access 2000. I have a report with several controls, three
of
which are named "Game 1", "Game 2", and "Game 3" that receive their
values
from a query that the report is based upon. I have another control
named
"Series" that receives the sum of the three game values. Data is
entered
on
a weekly basis.
Problem:
There is another control named "High Series" that is supposed to
receive
the
highest value from the "Series" control. "High Series" control
source
is
set
to:
=Max([Text14]), Text14 representing the "Series" control. No value
is
returned to "High Series" using this function. Could someone please
help,
I'm new at this and not yet familiar with how all these functions
are
suppose to work and where?

Hugh
Click to expand...
Click to expand...
Click to expand...
 
Back
Top