Help me show quantities based on sizes!

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

I am trying to create somewhat of a "pivot table report"
based on a query using size(ColumnLabelCode)as the critera
for the quantity(QuantityOrdered) showing up.

Im using a textbox in the report and entering the formula
=IIf([ColumnLabelCode_Label]="SM",[Sum Of
QuantityOrdered_Label],""). All I am getting is "error"
when I view the report.

What am I missing? Thanks
 
You don't tell us anything about the structure of the report or the report's
recordsource, but the name you're using for a control or field name gives me
a momentary pause:

Sum Of QuantityOrdered_Label

Is this the name of a label on the report? If yes, then you can't use that
in the IIf expression, as it has no value.
 
My mistake...the information is from a query based on
purchase order detail information. In the query one
column holds the values SM, MD, LG, XL, in it and I want
to report in pivot format the quantities column based on
the sizes. I entered the expression wrong it should read
=IIf([ColumnLabelCode]="SM",[Sum Of QuantityOrdered],"")
etc... If I drop the ="SM" I can get random information,
as soon as I put the critera ="SM" I get nothing. Any
other ideas on what the heck I'm doing wrong?
Thanks again.

-----Original Message-----
You don't tell us anything about the structure of the report or the report's
recordsource, but the name you're using for a control or field name gives me
a momentary pause:

Sum Of QuantityOrdered_Label

Is this the name of a label on the report? If yes, then you can't use that
in the IIf expression, as it has no value.

--

Ken Snell
<MS ACCESS MVP>

I am trying to create somewhat of a "pivot table report"
based on a query using size(ColumnLabelCode)as the critera
for the quantity(QuantityOrdered) showing up.

Im using a textbox in the report and entering the formula
=IIf([ColumnLabelCode_Label]="SM",[Sum Of
QuantityOrdered_Label],""). All I am getting is "error"
when I view the report.

What am I missing? Thanks
Click to expand...


.
Click to expand...
 
By "error", I assume you mean "#Error" being displayed in the textbox on the
report?

In which section of the report is this textbox located? Do you have a
control named ColumnLabelCode on the report, and is that control bound to
the field of the same name? What is the source of Sum Of QuantityOrdered --
a query?

I'm sorry, but we cannot see your report nor your query, so we need
additional information.
--

Ken Snell
<MS ACCESS MVP>


My mistake...the information is from a query based on
purchase order detail information. In the query one
column holds the values SM, MD, LG, XL, in it and I want
to report in pivot format the quantities column based on
the sizes. I entered the expression wrong it should read
=IIf([ColumnLabelCode]="SM",[Sum Of QuantityOrdered],"")
etc... If I drop the ="SM" I can get random information,
as soon as I put the critera ="SM" I get nothing. Any
other ideas on what the heck I'm doing wrong?
Thanks again.

-----Original Message-----
You don't tell us anything about the structure of the report or the report's
recordsource, but the name you're using for a control or field name gives me
a momentary pause:

Sum Of QuantityOrdered_Label

Is this the name of a label on the report? If yes, then you can't use that
in the IIf expression, as it has no value.

--

Ken Snell
<MS ACCESS MVP>

I am trying to create somewhat of a "pivot table report"
based on a query using size(ColumnLabelCode)as the critera
for the quantity(QuantityOrdered) showing up.

Im using a textbox in the report and entering the formula
=IIf([ColumnLabelCode_Label]="SM",[Sum Of
QuantityOrdered_Label],""). All I am getting is "error"
when I view the report.

What am I missing? Thanks
Click to expand...


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