additional parameter boxes popping up

[Guest]

I know I'm probably driving you guys insane. I have footer sections set up
for a report that have label names not included in my tables. When I open my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc. How do I get rid of these? Do I need to include these labels in
my query design?

 

[Rick B]

If they are labels, you will not get that. It sounds like you have placed
these in an unbound text box and put something like...

=[Total Specs]

Just use labels, not unbound text boxes.

If you do need this in a text box, then put the words in quotes.

="Total Specs"

 

[Guest]

I did have the labels connected to unbound text boxes. I thought that was
what I needed to do if I needed to post the sum of something from the report
by the label. For example: I have 6 entries in the column named "sales" and
I want my group footer to have the label "total sales" and then the sum of
the sales column to the right of the label.

If they are labels, you will not get that. It sounds like you have placed
these in an unbound text box and put something like...

=[Total Specs]

Just use labels, not unbound text boxes.

If you do need this in a text box, then put the words in quotes.

="Total Specs"

--
Rick B

I know I'm probably driving you guys insane. I have footer sections set up
for a report that have label names not included in my tables. When I open
my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc. How do I get rid of these? Do I need to include these labels
in
my query design?

 

[Rick B]

Either put the literal in a separate control or use quotes...

= "Total Sales: " & Sum([SomeFieldName])

I typically do these as two controls so I can line them up separately.

--
Rick B

I did have the labels connected to unbound text boxes. I thought that was
what I needed to do if I needed to post the sum of something from the
report
by the label. For example: I have 6 entries in the column named "sales"
and
I want my group footer to have the label "total sales" and then the sum of
the sales column to the right of the label.

If they are labels, you will not get that. It sounds like you have
placed
these in an unbound text box and put something like...

=[Total Specs]

Just use labels, not unbound text boxes.

If you do need this in a text box, then put the words in quotes.

="Total Specs"

--
Rick B

I know I'm probably driving you guys insane. I have footer sections set
up
for a report that have label names not included in my tables. When I
open
my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc. How do I get rid of these? Do I need to include these
labels
in
my query design?

 

[Guest]

Okay, I'm probably having a blonde moment, but when I enter
= "Total Sales: " & Sum([Sales])
it shows exactly = "Total Sales: " & Sum([Sales]) on my report.

The way I had it originally was like this
Total Sales: =Abs(sum([sales]>500))

Total Sales was the label attached to an unbound box and the expression was
the control for the text box. The report works, but I just need to get rid
of the parameter boxes so it doesn't confuse other users.

Either put the literal in a separate control or use quotes...

= "Total Sales: " & Sum([SomeFieldName])

I typically do these as two controls so I can line them up separately.

--
Rick B

I did have the labels connected to unbound text boxes. I thought that was
what I needed to do if I needed to post the sum of something from the
report
by the label. For example: I have 6 entries in the column named "sales"
and
I want my group footer to have the label "total sales" and then the sum of
the sales column to the right of the label.

If they are labels, you will not get that. It sounds like you have
placed
these in an unbound text box and put something like...

=[Total Specs]

Just use labels, not unbound text boxes.

If you do need this in a text box, then put the words in quotes.

="Total Specs"

--
Rick B



I know I'm probably driving you guys insane. I have footer sections set
up
for a report that have label names not included in my tables. When I
open
my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc. How do I get rid of these? Do I need to include these
labels
in
my query design?

 

[Guest]

Did you try a dfuntion:

=DSum("[Sales]","Name of your query","Sales >500")

This will give you the sum of sales for all sales greater than 500 in this
particular query.

Okay, I'm probably having a blonde moment, but when I enter
= "Total Sales: " & Sum([Sales])
it shows exactly = "Total Sales: " & Sum([Sales]) on my report.

The way I had it originally was like this
Total Sales: =Abs(sum([sales]>500))

Total Sales was the label attached to an unbound box and the expression was
the control for the text box. The report works, but I just need to get rid
of the parameter boxes so it doesn't confuse other users.

Either put the literal in a separate control or use quotes...

= "Total Sales: " & Sum([SomeFieldName])

I typically do these as two controls so I can line them up separately.

--
Rick B

I did have the labels connected to unbound text boxes. I thought that was
what I needed to do if I needed to post the sum of something from the
report
by the label. For example: I have 6 entries in the column named "sales"
and
I want my group footer to have the label "total sales" and then the sum of
the sales column to the right of the label.


:

If they are labels, you will not get that. It sounds like you have
placed
these in an unbound text box and put something like...

=[Total Specs]

Just use labels, not unbound text boxes.

If you do need this in a text box, then put the words in quotes.

="Total Specs"

--
Rick B



I know I'm probably driving you guys insane. I have footer sections set
up
for a report that have label names not included in my tables. When I
open
my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc. How do I get rid of these? Do I need to include these
labels
in
my query design?

 

[Guest]

Getting the answer to the "sum" isn't my problem. I get the correct
information in the report, but when I open the report I get multiple
parameter boxes with the label names that I have listed for each expression.
I can open the report by just hitting the Enter key when each parameter pops
up and it pulls the data based on my query. I just want to eliminate the pop
up parameter boxes to make the report less confusing for other users.

Did you try a dfuntion:

=DSum("[Sales]","Name of your query","Sales >500")

This will give you the sum of sales for all sales greater than 500 in this
particular query.

Okay, I'm probably having a blonde moment, but when I enter
= "Total Sales: " & Sum([Sales])
it shows exactly = "Total Sales: " & Sum([Sales]) on my report.

The way I had it originally was like this
Total Sales: =Abs(sum([sales]>500))

Total Sales was the label attached to an unbound box and the expression was
the control for the text box. The report works, but I just need to get rid
of the parameter boxes so it doesn't confuse other users.

Either put the literal in a separate control or use quotes...

= "Total Sales: " & Sum([SomeFieldName])

I typically do these as two controls so I can line them up separately.

--
Rick B



I did have the labels connected to unbound text boxes. I thought that was
what I needed to do if I needed to post the sum of something from the
report
by the label. For example: I have 6 entries in the column named "sales"
and
I want my group footer to have the label "total sales" and then the sum of
the sales column to the right of the label.


:

If they are labels, you will not get that. It sounds like you have
placed
these in an unbound text box and put something like...

=[Total Specs]

Just use labels, not unbound text boxes.

If you do need this in a text box, then put the words in quotes.

="Total Specs"

--
Rick B



I know I'm probably driving you guys insane. I have footer sections set
up
for a report that have label names not included in my tables. When I
open
my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc. How do I get rid of these? Do I need to include these
labels
in
my query design?

 

[Guest]

I would not have the labels bound. I would get rid of the bound labels and
create unbound labels. Other than that, I don't know why it would be giving
you a parameter. I think this might be your only solution.

Getting the answer to the "sum" isn't my problem. I get the correct
information in the report, but when I open the report I get multiple
parameter boxes with the label names that I have listed for each expression.
I can open the report by just hitting the Enter key when each parameter pops
up and it pulls the data based on my query. I just want to eliminate the pop
up parameter boxes to make the report less confusing for other users.

Did you try a dfuntion:

=DSum("[Sales]","Name of your query","Sales >500")

This will give you the sum of sales for all sales greater than 500 in this
particular query.

Okay, I'm probably having a blonde moment, but when I enter
= "Total Sales: " & Sum([Sales])
it shows exactly = "Total Sales: " & Sum([Sales]) on my report.

The way I had it originally was like this
Total Sales: =Abs(sum([sales]>500))

Total Sales was the label attached to an unbound box and the expression was
the control for the text box. The report works, but I just need to get rid
of the parameter boxes so it doesn't confuse other users.

:

Either put the literal in a separate control or use quotes...

= "Total Sales: " & Sum([SomeFieldName])

I typically do these as two controls so I can line them up separately.

--
Rick B



I did have the labels connected to unbound text boxes. I thought that was
what I needed to do if I needed to post the sum of something from the
report
by the label. For example: I have 6 entries in the column named "sales"
and
I want my group footer to have the label "total sales" and then the sum of
the sales column to the right of the label.


:

If they are labels, you will not get that. It sounds like you have
placed
these in an unbound text box and put something like...

=[Total Specs]

Just use labels, not unbound text boxes.

If you do need this in a text box, then put the words in quotes.

="Total Specs"

--
Rick B



I know I'm probably driving you guys insane. I have footer sections set
up
for a report that have label names not included in my tables. When I
open
my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc. How do I get rid of these? Do I need to include these
labels
in
my query design?

 

[Guest]

Forgive me if this sounds stupid, but how do I create an unboud label? My
label isn't bound to my text box. I created them separately. I'm using up
the few brain cells I have left trying to figure this out.

I would not have the labels bound. I would get rid of the bound labels and
create unbound labels. Other than that, I don't know why it would be giving
you a parameter. I think this might be your only solution.

Getting the answer to the "sum" isn't my problem. I get the correct
information in the report, but when I open the report I get multiple
parameter boxes with the label names that I have listed for each expression.
I can open the report by just hitting the Enter key when each parameter pops
up and it pulls the data based on my query. I just want to eliminate the pop
up parameter boxes to make the report less confusing for other users.

Did you try a dfuntion:

=DSum("[Sales]","Name of your query","Sales >500")

This will give you the sum of sales for all sales greater than 500 in this
particular query.

:

Okay, I'm probably having a blonde moment, but when I enter
= "Total Sales: " & Sum([Sales])
it shows exactly = "Total Sales: " & Sum([Sales]) on my report.

The way I had it originally was like this
Total Sales: =Abs(sum([sales]>500))

Total Sales was the label attached to an unbound box and the expression was
the control for the text box. The report works, but I just need to get rid
of the parameter boxes so it doesn't confuse other users.

:

Either put the literal in a separate control or use quotes...

= "Total Sales: " & Sum([SomeFieldName])

I typically do these as two controls so I can line them up separately.

--
Rick B



I did have the labels connected to unbound text boxes. I thought that was
what I needed to do if I needed to post the sum of something from the
report
by the label. For example: I have 6 entries in the column named "sales"
and
I want my group footer to have the label "total sales" and then the sum of
the sales column to the right of the label.


:

If they are labels, you will not get that. It sounds like you have
placed
these in an unbound text box and put something like...

=[Total Specs]

Just use labels, not unbound text boxes.

If you do need this in a text box, then put the words in quotes.

="Total Specs"

--
Rick B



I know I'm probably driving you guys insane. I have footer sections set
up
for a report that have label names not included in my tables. When I
open
my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc. How do I get rid of these? Do I need to include these
labels
in
my query design?

 

[Guest]

Without actually seeing your report, it is hard to understand what is going
on. The only time I get a parameter box is when I have a control on my
report that is not included in the underlying table or query. The report is
asking you what this data should be since it cannot find it in the underlying
table. You said that the report is tied to a table and not a query, right?
If it is tied to a query, make sure that you don't have a parameter in your
query.

Forgive me if this sounds stupid, but how do I create an unboud label? My
label isn't bound to my text box. I created them separately. I'm using up
the few brain cells I have left trying to figure this out.

I would not have the labels bound. I would get rid of the bound labels and
create unbound labels. Other than that, I don't know why it would be giving
you a parameter. I think this might be your only solution.

Getting the answer to the "sum" isn't my problem. I get the correct
information in the report, but when I open the report I get multiple
parameter boxes with the label names that I have listed for each expression.
I can open the report by just hitting the Enter key when each parameter pops
up and it pulls the data based on my query. I just want to eliminate the pop
up parameter boxes to make the report less confusing for other users.

:

Did you try a dfuntion:

=DSum("[Sales]","Name of your query","Sales >500")

This will give you the sum of sales for all sales greater than 500 in this
particular query.

:

Okay, I'm probably having a blonde moment, but when I enter
= "Total Sales: " & Sum([Sales])
it shows exactly = "Total Sales: " & Sum([Sales]) on my report.

The way I had it originally was like this
Total Sales: =Abs(sum([sales]>500))

Total Sales was the label attached to an unbound box and the expression was
the control for the text box. The report works, but I just need to get rid
of the parameter boxes so it doesn't confuse other users.

:

Either put the literal in a separate control or use quotes...

= "Total Sales: " & Sum([SomeFieldName])

I typically do these as two controls so I can line them up separately.

--
Rick B



I did have the labels connected to unbound text boxes. I thought that was
what I needed to do if I needed to post the sum of something from the
report
by the label. For example: I have 6 entries in the column named "sales"
and
I want my group footer to have the label "total sales" and then the sum of
the sales column to the right of the label.


:

If they are labels, you will not get that. It sounds like you have
placed
these in an unbound text box and put something like...

=[Total Specs]

Just use labels, not unbound text boxes.

If you do need this in a text box, then put the words in quotes.

="Total Specs"

--
Rick B



I know I'm probably driving you guys insane. I have footer sections set
up
for a report that have label names not included in my tables. When I
open
my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc. How do I get rid of these? Do I need to include these
labels
in
my query design?

 

[Guest]

Okay I think we're narrowing it down. The label names are not in my table or
query. For example, in my table I have a field that is desinated with an "x"
and in my query I am asking to pull all records that have an "x" in that
field. At the bottom of the report I want to state "Total number of field:"
and have the number out to the side. I have the formulas to get my
calculations, but since "Total Number of Field" isn't in my tabel or query I
get a parameter box. I'm sorry to be such a nuisance. Any suggestions?

Without actually seeing your report, it is hard to understand what is going
on. The only time I get a parameter box is when I have a control on my
report that is not included in the underlying table or query. The report is
asking you what this data should be since it cannot find it in the underlying
table. You said that the report is tied to a table and not a query, right?
If it is tied to a query, make sure that you don't have a parameter in your
query.

Forgive me if this sounds stupid, but how do I create an unboud label? My
label isn't bound to my text box. I created them separately. I'm using up
the few brain cells I have left trying to figure this out.

I would not have the labels bound. I would get rid of the bound labels and
create unbound labels. Other than that, I don't know why it would be giving
you a parameter. I think this might be your only solution.

:

Getting the answer to the "sum" isn't my problem. I get the correct
information in the report, but when I open the report I get multiple
parameter boxes with the label names that I have listed for each expression.
I can open the report by just hitting the Enter key when each parameter pops
up and it pulls the data based on my query. I just want to eliminate the pop
up parameter boxes to make the report less confusing for other users.

:

Did you try a dfuntion:

=DSum("[Sales]","Name of your query","Sales >500")

This will give you the sum of sales for all sales greater than 500 in this
particular query.

:

Okay, I'm probably having a blonde moment, but when I enter
= "Total Sales: " & Sum([Sales])
it shows exactly = "Total Sales: " & Sum([Sales]) on my report.

The way I had it originally was like this
Total Sales: =Abs(sum([sales]>500))

Total Sales was the label attached to an unbound box and the expression was
the control for the text box. The report works, but I just need to get rid
of the parameter boxes so it doesn't confuse other users.

:

Either put the literal in a separate control or use quotes...

= "Total Sales: " & Sum([SomeFieldName])

I typically do these as two controls so I can line them up separately.

--
Rick B



I did have the labels connected to unbound text boxes. I thought that was
what I needed to do if I needed to post the sum of something from the
report
by the label. For example: I have 6 entries in the column named "sales"
and
I want my group footer to have the label "total sales" and then the sum of
the sales column to the right of the label.


:

If they are labels, you will not get that. It sounds like you have
placed
these in an unbound text box and put something like...

=[Total Specs]

Just use labels, not unbound text boxes.

If you do need this in a text box, then put the words in quotes.

="Total Specs"

--
Rick B



I know I'm probably driving you guys insane. I have footer sections set
up
for a report that have label names not included in my tables. When I
open
my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc. How do I get rid of these? Do I need to include these
labels
in
my query design?

 

[Guest]

Are you sure you aren't confusing a label with a text box? A label is simply
text - not bound to anything so it should not result in a parameter. The
text box has a control or a fomula to control the results. The label can
contain anything you want to have in it so it has to be the text box is the
one that is causing your parameter.

Okay I think we're narrowing it down. The label names are not in my table or
query. For example, in my table I have a field that is desinated with an "x"
and in my query I am asking to pull all records that have an "x" in that
field. At the bottom of the report I want to state "Total number of field:"
and have the number out to the side. I have the formulas to get my
calculations, but since "Total Number of Field" isn't in my tabel or query I
get a parameter box. I'm sorry to be such a nuisance. Any suggestions?

Without actually seeing your report, it is hard to understand what is going
on. The only time I get a parameter box is when I have a control on my
report that is not included in the underlying table or query. The report is
asking you what this data should be since it cannot find it in the underlying
table. You said that the report is tied to a table and not a query, right?
If it is tied to a query, make sure that you don't have a parameter in your
query.

Forgive me if this sounds stupid, but how do I create an unboud label? My
label isn't bound to my text box. I created them separately. I'm using up
the few brain cells I have left trying to figure this out.

:

I would not have the labels bound. I would get rid of the bound labels and
create unbound labels. Other than that, I don't know why it would be giving
you a parameter. I think this might be your only solution.

:

Getting the answer to the "sum" isn't my problem. I get the correct
information in the report, but when I open the report I get multiple
parameter boxes with the label names that I have listed for each expression.
I can open the report by just hitting the Enter key when each parameter pops
up and it pulls the data based on my query. I just want to eliminate the pop
up parameter boxes to make the report less confusing for other users.

:

Did you try a dfuntion:

=DSum("[Sales]","Name of your query","Sales >500")

This will give you the sum of sales for all sales greater than 500 in this
particular query.

:

Okay, I'm probably having a blonde moment, but when I enter
= "Total Sales: " & Sum([Sales])
it shows exactly = "Total Sales: " & Sum([Sales]) on my report.

The way I had it originally was like this
Total Sales: =Abs(sum([sales]>500))

Total Sales was the label attached to an unbound box and the expression was
the control for the text box. The report works, but I just need to get rid
of the parameter boxes so it doesn't confuse other users.

:

Either put the literal in a separate control or use quotes...

= "Total Sales: " & Sum([SomeFieldName])

I typically do these as two controls so I can line them up separately.

--
Rick B



I did have the labels connected to unbound text boxes. I thought that was
what I needed to do if I needed to post the sum of something from the
report
by the label. For example: I have 6 entries in the column named "sales"
and
I want my group footer to have the label "total sales" and then the sum of
the sales column to the right of the label.


:

If they are labels, you will not get that. It sounds like you have
placed
these in an unbound text box and put something like...

=[Total Specs]

Just use labels, not unbound text boxes.

If you do need this in a text box, then put the words in quotes.

="Total Specs"

--
Rick B



I know I'm probably driving you guys insane. I have footer sections set
up
for a report that have label names not included in my tables. When I
open
my
report I get parameter boxes for each label name ie. Total Specs, Total
sales, etc. How do I get rid of these? Do I need to include these
labels
in
my query design?