Duane

[Hugh]

Thank you very much for your assistance Duane. I plugged your expr into
"Games Played" and so far it seems to have solved the problem. May I ask you
one more question, when I run the report a message box comes up asking for
input for each game, I just click ok without entering any values for each
game and then it runs ok. My question is, is there a way to stop the message
box from appearing? Also, do you know of a book or books that would be
beneficial to me in solving future problems and understanding the proper
syntax to use in a given situation, such as you provided me? I have only
been using Access now for about a month and I could use all the help I can
get, I want to learn this program as much as possible. Thank you again.


Hugh

 

[Duane Hookom]

Please respond in the same thread so we don't have to search for the
original post. What is your message box asking for? What are your field
names in the report? I thought you had fields [Game 1],...etc.

 

[Hugh]

I'm sorry Duane, I tried to send it before in the same message but it
bounced, I hope this one makes it. The message box is asking for input for
each game, "Game 1", then "Game 2", etc. After I click each one "ok" once
the report opens and everything is fine. I would like to stop the message
boxes from appearing.

Hugh

Please respond in the same thread so we don't have to search for the
original post. What is your message box asking for? What are your field
names in the report? I thought you had fields [Game 1],...etc.

--
Duane Hookom
MS Access MVP

Thank you very much for your assistance Duane. I plugged your expr into
"Games Played" and so far it seems to have solved the problem. May I ask you
one more question, when I run the report a message box comes up asking for
input for each game, I just click ok without entering any values for each
game and then it runs ok. My question is, is there a way to stop the message
box from appearing? Also, do you know of a book or books that would be
beneficial to me in solving future problems and understanding the proper
syntax to use in a given situation, such as you provided me? I have only
been using Access now for about a month and I could use all the help I can
get, I want to learn this program as much as possible. Thank you again.


Hugh

 

[Duane Hookom]

From your earlier post, I thought you had fields with those names? As I just
asked, "What are your field names in the report"?

--
Duane Hookom
MS Access MVP

I'm sorry Duane, I tried to send it before in the same message but it
bounced, I hope this one makes it. The message box is asking for input for
each game, "Game 1", then "Game 2", etc. After I click each one "ok" once
the report opens and everything is fine. I would like to stop the message
boxes from appearing.

Hugh

Please respond in the same thread so we don't have to search for the
original post. What is your message box asking for? What are your field
names in the report? I thought you had fields [Game 1],...etc.

--
Duane Hookom
MS Access MVP

Thank you very much for your assistance Duane. I plugged your expr into
"Games Played" and so far it seems to have solved the problem. May I

ask
you

one more question, when I run the report a message box comes up asking for
input for each game, I just click ok without entering any values for each
game and then it runs ok. My question is, is there a way to stop the message
box from appearing? Also, do you know of a book or books that would be
beneficial to me in solving future problems and understanding the proper
syntax to use in a given situation, such as you provided me? I have only
been using Access now for about a month and I could use all the help I can
get, I want to learn this program as much as possible. Thank you again.


Hugh

 

[Hugh]

Duane,

That problem is solved. I do, however, have one more that I can't seem to
overcome as yet. The "Games 1,2, &3" are summed every week and a total for
that series is recorded in a "Series" column. It is necessary for me to find
the high series to date each week and record that in a control called "High
Series". I set the control source for "High Series" like so: =Max([Text14]),
Text14 representing the "Series" control. This does not work, any
suggestions?

I want to thank you for your time Duane, you have been a tremendous help to
me. I was elected secretary of our dart league this year and this program,
even though I'm still a novice at it, has saved hours upon hours, I love it.

Hugh

From your earlier post, I thought you had fields with those names? As I just
asked, "What are your field names in the report"?

--
Duane Hookom
MS Access MVP

I'm sorry Duane, I tried to send it before in the same message but it
bounced, I hope this one makes it. The message box is asking for input for
each game, "Game 1", then "Game 2", etc. After I click each one "ok" once
the report opens and everything is fine. I would like to stop the message
boxes from appearing.

Hugh

Please respond in the same thread so we don't have to search for the
original post. What is your message box asking for? What are your field
names in the report? I thought you had fields [Game 1],...etc.

--
Duane Hookom
MS Access MVP


Thank you very much for your assistance Duane. I plugged your expr into
"Games Played" and so far it seems to have solved the problem. May I ask
you
one more question, when I run the report a message box comes up

asking
for

input for each game, I just click ok without entering any values for each
game and then it runs ok. My question is, is there a way to stop the
message
box from appearing? Also, do you know of a book or books that would be
beneficial to me in solving future problems and understanding the proper
syntax to use in a given situation, such as you provided me? I have only
been using Access now for about a month and I could use all the help

I
can

get, I want to learn this program as much as possible. Thank you again.


Hugh

 

[Duane Hookom]

You can't use an aggregate of a "control". You can use
=Max([TheControlSourceExpressionFromText14])

--
Duane Hookom
MS Access MVP

Duane,

That problem is solved. I do, however, have one more that I can't seem to
overcome as yet. The "Games 1,2, &3" are summed every week and a total for
that series is recorded in a "Series" column. It is necessary for me to find
the high series to date each week and record that in a control called "High
Series". I set the control source for "High Series" like so: =Max([Text14]),
Text14 representing the "Series" control. This does not work, any
suggestions?

I want to thank you for your time Duane, you have been a tremendous help to
me. I was elected secretary of our dart league this year and this program,
even though I'm still a novice at it, has saved hours upon hours, I love it.

Hugh

From your earlier post, I thought you had fields with those names? As I just
asked, "What are your field names in the report"?

--
Duane Hookom
MS Access MVP

I'm sorry Duane, I tried to send it before in the same message but it
bounced, I hope this one makes it. The message box is asking for input for
each game, "Game 1", then "Game 2", etc. After I click each one "ok" once
the report opens and everything is fine. I would like to stop the message
boxes from appearing.

Hugh


Please respond in the same thread so we don't have to search for the
original post. What is your message box asking for? What are your field
names in the report? I thought you had fields [Game 1],...etc.

--
Duane Hookom
MS Access MVP


Thank you very much for your assistance Duane. I plugged your expr into
"Games Played" and so far it seems to have solved the problem. May

I
ask

you
one more question, when I run the report a message box comes up asking
for
input for each game, I just click ok without entering any values for
each
game and then it runs ok. My question is, is there a way to stop the
message
box from appearing? Also, do you know of a book or books that

would

be have
only

help

I