Graph won't show

L

Lydia

Hi,

I have a graph that is based on a crosstab query and have 4 fields that take
input data or parameter values from four drop-down boxes on a form.

When I run the report just by clicking on the report without using the form
that has four drop-down boxes, it works fine no matter what way I entered
those parameter values. However, if I use the form and not select some values
on the form, the graph stop showing. Graphs will show if I select most of
values on the form.


I just wonder what I did wrong.

Thanks.

Lydia
 
D

Duane Hookom

What is the Row Source of the graph? Did you set the data types of the
parameters?
 
L

Lydia

The following is the row source:
TRANSFORM Sum(qryC1000DataMOP.C1000) AS SumOfC1000 SELECT
qryC1000DataMOP.NMIS FROM qryC1000DataMOP GROUP BY qryC1000DataMOP.NMIS ORDER
BY qryC1000DataMOP.NMIS, qryC1000DataMOP.NMOP PIVOT qryC1000DataMOP.NMOP;

Yes. I did set paramers data types in the parameters window.

Thanks.

Lydia



Access/VB Programmer
 
D

Duane Hookom

I guess I should have asked to see the SQL of the query containing the
references to the drop-down boxes since that seems to be where the error is
originating.
 
L

Lydia

Hi Juane,

I feel sorry to trouble you with this. It is much easier for me look at it
in the design screen.

The crosstab query is based on a query that has two other queries in it.
These two other queries are the ones that contain the criteria.

The following is the SQL from the first of the two queries that contain
criteria. If it is too much trouble, please ignore it. I guess I will try
harder myself to see if I can find out something is wrong.
Thanks.

PARAMETERS [forms]![frmOverallReportCriteria]![cmbPL] Text ( 255 ),
[forms]![frmOverallReportCriteria]![cmbCT] Text ( 255 );
SELECT qryC1000DataMOPChryslerI.Product, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, Val([MOP]) AS NMOP,
qryC1000DataMOPChryslerI.MOP, Val([MIS/Miles]) AS NMIS,
qryC1000DataMOPChryslerI.[YTD/CMP], qryC1000DataMOPChryslerI.[C/1000],
Format([C/1000],"0.00") AS C1000, qryC1000DataMOPChryslerI.ModelYear
FROM qryC1000DataMOPChryslerI
WHERE
(((qryC1000DataMOPChryslerI.PL)=[forms]![frmOverallReportCriteria]![cmbPL])
AND
((qryC1000DataMOPChryslerI.CT)=[forms]![frmOverallReportCriteria]![cmbCT])
AND (Not ([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND (Not
([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL)=[forms]![frmOverallReportCriteria]![cmbPL])
AND ((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND
(([Forms]![frmOverallReportCriteria]![CmbPL])="Totals")) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND
(([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT])="Totals") AND
(([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)=[forms]![frmOverallReportCriteria]![cmbCT])
AND (([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null))
ORDER BY qryC1000DataMOPChryslerI.Product, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, Val([MOP]), Val([MIS/Miles]),
qryC1000DataMOPChryslerI.ModelYear, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, qryC1000DataMOPChryslerI.MOP;


Lydia
 
D

Duane Hookom

I would use a saved query as the Row Source of the graph. You could use a
little code in the frmOverallReportCriteria that would change the SQL
property of the saved query based on the values selected in the combo boxes.
Your DAO code might look something like:

Dim strSQL as String
Dim strWhere as String
strWhere = "1=1 "
If Not IsNull(Me.cmbCT) Then
strWhere = strWhere & " AND CT = """ & Me.cmbCT & """ "
End IF
' --- other criteria building ---
strSQL = "SELECT Product, PL, CT, Val([MOP]) AS NMOP, MOP, " & _
"Val([MIS/Miles]) AS NMIS, [YTD/CMP], [C/1000], " & _
"Format([C/1000],"0.00") AS C1000, ModelYear " & _
"FROM qryC1000DataMOPChryslerI WHERE " & strWhere

CurrentDb.QueryDefs("qselForGraph").SQL = strSQL
'--- then open the report with the graph ---
--
Duane Hookom
Microsoft Access MVP


Lydia said:
Hi Juane,

I feel sorry to trouble you with this. It is much easier for me look at it
in the design screen.

The crosstab query is based on a query that has two other queries in it.
These two other queries are the ones that contain the criteria.

The following is the SQL from the first of the two queries that contain
criteria. If it is too much trouble, please ignore it. I guess I will try
harder myself to see if I can find out something is wrong.
Thanks.

PARAMETERS [forms]![frmOverallReportCriteria]![cmbPL] Text ( 255 ),
[forms]![frmOverallReportCriteria]![cmbCT] Text ( 255 );
SELECT qryC1000DataMOPChryslerI.Product, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, Val([MOP]) AS NMOP,
qryC1000DataMOPChryslerI.MOP, Val([MIS/Miles]) AS NMIS,
qryC1000DataMOPChryslerI.[YTD/CMP], qryC1000DataMOPChryslerI.[C/1000],
Format([C/1000],"0.00") AS C1000, qryC1000DataMOPChryslerI.ModelYear
FROM qryC1000DataMOPChryslerI
WHERE
(((qryC1000DataMOPChryslerI.PL)=[forms]![frmOverallReportCriteria]![cmbPL])
AND
((qryC1000DataMOPChryslerI.CT)=[forms]![frmOverallReportCriteria]![cmbCT])
AND (Not ([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND (Not
([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL)=[forms]![frmOverallReportCriteria]![cmbPL])
AND ((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND
(([Forms]![frmOverallReportCriteria]![CmbPL])="Totals")) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND
(([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT])="Totals") AND
(([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)=[forms]![frmOverallReportCriteria]![cmbCT])
AND (([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null))
ORDER BY qryC1000DataMOPChryslerI.Product, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, Val([MOP]), Val([MIS/Miles]),
qryC1000DataMOPChryslerI.ModelYear, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, qryC1000DataMOPChryslerI.MOP;


Lydia
--
Access/VB Programmer



Duane Hookom said:
I guess I should have asked to see the SQL of the query containing the
references to the drop-down boxes since that seems to be where the error is
originating.
Click to expand...
Click to expand...
 
L

Lydia

Hi Duane,

Thanks for taking time to look into it.

I modified my query and it still won't take any null value from the criteria
entry form. However when I select "Totals", graph shows, and "Totals" means
the same as Null in my case. So I just made sure "Totals" always kicks in if
user doesn't select anything from the drop down box. This way the graph works
fine.

I still can't figure out why no selection of criteria results in graph not
showing. If you may have some suggestion, I would love to hear it. Otherwise,
things work for me for now.

Thanks a lot.

Lydia
--
Access/VB Programmer



Duane Hookom said:
I would use a saved query as the Row Source of the graph. You could use a
little code in the frmOverallReportCriteria that would change the SQL
property of the saved query based on the values selected in the combo boxes.
Your DAO code might look something like:

Dim strSQL as String
Dim strWhere as String
strWhere = "1=1 "
If Not IsNull(Me.cmbCT) Then
strWhere = strWhere & " AND CT = """ & Me.cmbCT & """ "
End IF
' --- other criteria building ---
strSQL = "SELECT Product, PL, CT, Val([MOP]) AS NMOP, MOP, " & _
"Val([MIS/Miles]) AS NMIS, [YTD/CMP], [C/1000], " & _
"Format([C/1000],"0.00") AS C1000, ModelYear " & _
"FROM qryC1000DataMOPChryslerI WHERE " & strWhere

CurrentDb.QueryDefs("qselForGraph").SQL = strSQL
'--- then open the report with the graph ---
--
Duane Hookom
Microsoft Access MVP


Lydia said:
Hi Juane,

I feel sorry to trouble you with this. It is much easier for me look at it
in the design screen.

The crosstab query is based on a query that has two other queries in it.
These two other queries are the ones that contain the criteria.

The following is the SQL from the first of the two queries that contain
criteria. If it is too much trouble, please ignore it. I guess I will try
harder myself to see if I can find out something is wrong.
Thanks.

PARAMETERS [forms]![frmOverallReportCriteria]![cmbPL] Text ( 255 ),
[forms]![frmOverallReportCriteria]![cmbCT] Text ( 255 );
SELECT qryC1000DataMOPChryslerI.Product, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, Val([MOP]) AS NMOP,
qryC1000DataMOPChryslerI.MOP, Val([MIS/Miles]) AS NMIS,
qryC1000DataMOPChryslerI.[YTD/CMP], qryC1000DataMOPChryslerI.[C/1000],
Format([C/1000],"0.00") AS C1000, qryC1000DataMOPChryslerI.ModelYear
FROM qryC1000DataMOPChryslerI
WHERE
(((qryC1000DataMOPChryslerI.PL)=[forms]![frmOverallReportCriteria]![cmbPL])
AND
((qryC1000DataMOPChryslerI.CT)=[forms]![frmOverallReportCriteria]![cmbCT])
AND (Not ([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND (Not
([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL)=[forms]![frmOverallReportCriteria]![cmbPL])
AND ((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND
(([Forms]![frmOverallReportCriteria]![CmbPL])="Totals")) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND
(([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT])="Totals") AND
(([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)=[forms]![frmOverallReportCriteria]![cmbCT])
AND (([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null))
ORDER BY qryC1000DataMOPChryslerI.Product, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, Val([MOP]), Val([MIS/Miles]),
qryC1000DataMOPChryslerI.ModelYear, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, qryC1000DataMOPChryslerI.MOP;


Lydia
--
Access/VB Programmer



Duane Hookom said:
I guess I should have asked to see the SQL of the query containing the
references to the drop-down boxes since that seems to be where the error is
originating.
--
Duane Hookom
Microsoft Access MVP


:

The following is the row source:
TRANSFORM Sum(qryC1000DataMOP.C1000) AS SumOfC1000 SELECT
qryC1000DataMOP.NMIS FROM qryC1000DataMOP GROUP BY qryC1000DataMOP.NMIS ORDER
BY qryC1000DataMOP.NMIS, qryC1000DataMOP.NMOP PIVOT qryC1000DataMOP.NMOP;

Yes. I did set paramers data types in the parameters window.

Thanks.

Lydia



Access/VB Programmer



:

What is the Row Source of the graph? Did you set the data types of the
parameters?

--
Duane Hookom
Microsoft Access MVP


:

Hi,

I have a graph that is based on a crosstab query and have 4 fields that take
input data or parameter values from four drop-down boxes on a form.

When I run the report just by clicking on the report without using the form
that has four drop-down boxes, it works fine no matter what way I entered
those parameter values. However, if I use the form and not select some values
on the form, the graph stop showing. Graphs will show if I select most of
values on the form.


I just wonder what I did wrong.

Thanks.

Lydia
Click to expand...
Click to expand...
Click to expand...
 
D

Duane Hookom

It looks like you have two combo boxes on the form. If they are both Null
then record must meet this criteria:
PL Is Null AND CT="TOTALS"
You might want to consider using Nz() like:
CT = Nz([Forms]...![cmbCT],"TOTALS")

--
Duane Hookom
Microsoft Access MVP


Lydia said:
Hi Duane,

Thanks for taking time to look into it.

I modified my query and it still won't take any null value from the criteria
entry form. However when I select "Totals", graph shows, and "Totals" means
the same as Null in my case. So I just made sure "Totals" always kicks in if
user doesn't select anything from the drop down box. This way the graph works
fine.

I still can't figure out why no selection of criteria results in graph not
showing. If you may have some suggestion, I would love to hear it. Otherwise,
things work for me for now.

Thanks a lot.

Lydia
--
Access/VB Programmer



Duane Hookom said:
I would use a saved query as the Row Source of the graph. You could use a
little code in the frmOverallReportCriteria that would change the SQL
property of the saved query based on the values selected in the combo boxes.
Your DAO code might look something like:

Dim strSQL as String
Dim strWhere as String
strWhere = "1=1 "
If Not IsNull(Me.cmbCT) Then
strWhere = strWhere & " AND CT = """ & Me.cmbCT & """ "
End IF
' --- other criteria building ---
strSQL = "SELECT Product, PL, CT, Val([MOP]) AS NMOP, MOP, " & _
"Val([MIS/Miles]) AS NMIS, [YTD/CMP], [C/1000], " & _
"Format([C/1000],"0.00") AS C1000, ModelYear " & _
"FROM qryC1000DataMOPChryslerI WHERE " & strWhere

CurrentDb.QueryDefs("qselForGraph").SQL = strSQL
'--- then open the report with the graph ---
--
Duane Hookom
Microsoft Access MVP


Lydia said:
Hi Juane,

I feel sorry to trouble you with this. It is much easier for me look at it
in the design screen.

The crosstab query is based on a query that has two other queries in it.
These two other queries are the ones that contain the criteria.

The following is the SQL from the first of the two queries that contain
criteria. If it is too much trouble, please ignore it. I guess I will try
harder myself to see if I can find out something is wrong.
Thanks.

PARAMETERS [forms]![frmOverallReportCriteria]![cmbPL] Text ( 255 ),
[forms]![frmOverallReportCriteria]![cmbCT] Text ( 255 );
SELECT qryC1000DataMOPChryslerI.Product, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, Val([MOP]) AS NMOP,
qryC1000DataMOPChryslerI.MOP, Val([MIS/Miles]) AS NMIS,
qryC1000DataMOPChryslerI.[YTD/CMP], qryC1000DataMOPChryslerI.[C/1000],
Format([C/1000],"0.00") AS C1000, qryC1000DataMOPChryslerI.ModelYear
FROM qryC1000DataMOPChryslerI
WHERE
(((qryC1000DataMOPChryslerI.PL)=[forms]![frmOverallReportCriteria]![cmbPL])
AND
((qryC1000DataMOPChryslerI.CT)=[forms]![frmOverallReportCriteria]![cmbCT])
AND (Not ([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND (Not
([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL)=[forms]![frmOverallReportCriteria]![cmbPL])
AND ((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND
(([Forms]![frmOverallReportCriteria]![CmbPL])="Totals")) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND
(([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT])="Totals") AND
(([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)=[forms]![frmOverallReportCriteria]![cmbCT])
AND (([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null))
ORDER BY qryC1000DataMOPChryslerI.Product, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, Val([MOP]), Val([MIS/Miles]),
qryC1000DataMOPChryslerI.ModelYear, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, qryC1000DataMOPChryslerI.MOP;


Lydia
--
Access/VB Programmer



:

I guess I should have asked to see the SQL of the query containing the
references to the drop-down boxes since that seems to be where the error is
originating.
--
Duane Hookom
Microsoft Access MVP


:

The following is the row source:
TRANSFORM Sum(qryC1000DataMOP.C1000) AS SumOfC1000 SELECT
qryC1000DataMOP.NMIS FROM qryC1000DataMOP GROUP BY qryC1000DataMOP.NMIS ORDER
BY qryC1000DataMOP.NMIS, qryC1000DataMOP.NMOP PIVOT qryC1000DataMOP.NMOP;

Yes. I did set paramers data types in the parameters window.

Thanks.

Lydia



Access/VB Programmer



:

What is the Row Source of the graph? Did you set the data types of the
parameters?

--
Duane Hookom
Microsoft Access MVP


:

Hi,

I have a graph that is based on a crosstab query and have 4 fields that take
input data or parameter values from four drop-down boxes on a form.

When I run the report just by clicking on the report without using the form
that has four drop-down boxes, it works fine no matter what way I entered
those parameter values. However, if I use the form and not select some values
on the form, the graph stop showing. Graphs will show if I select most of
values on the form.


I just wonder what I did wrong.

Thanks.

Lydia
Click to expand...
Click to expand...
Click to expand...
 
L

Lydia

You understand correctly. I thought about using Nz function but didn't quite
figure out how. I will give it a try as soon as I've got a change.

Thanks a lot.

Lydia
--
Access/VB Programmer



Duane Hookom said:
It looks like you have two combo boxes on the form. If they are both Null
then record must meet this criteria:
PL Is Null AND CT="TOTALS"
You might want to consider using Nz() like:
CT = Nz([Forms]...![cmbCT],"TOTALS")

--
Duane Hookom
Microsoft Access MVP


Lydia said:
Hi Duane,

Thanks for taking time to look into it.

I modified my query and it still won't take any null value from the criteria
entry form. However when I select "Totals", graph shows, and "Totals" means
the same as Null in my case. So I just made sure "Totals" always kicks in if
user doesn't select anything from the drop down box. This way the graph works
fine.

I still can't figure out why no selection of criteria results in graph not
showing. If you may have some suggestion, I would love to hear it. Otherwise,
things work for me for now.

Thanks a lot.

Lydia
--
Access/VB Programmer



Duane Hookom said:
I would use a saved query as the Row Source of the graph. You could use a
little code in the frmOverallReportCriteria that would change the SQL
property of the saved query based on the values selected in the combo boxes.
Your DAO code might look something like:

Dim strSQL as String
Dim strWhere as String
strWhere = "1=1 "
If Not IsNull(Me.cmbCT) Then
strWhere = strWhere & " AND CT = """ & Me.cmbCT & """ "
End IF
' --- other criteria building ---
strSQL = "SELECT Product, PL, CT, Val([MOP]) AS NMOP, MOP, " & _
"Val([MIS/Miles]) AS NMIS, [YTD/CMP], [C/1000], " & _
"Format([C/1000],"0.00") AS C1000, ModelYear " & _
"FROM qryC1000DataMOPChryslerI WHERE " & strWhere

CurrentDb.QueryDefs("qselForGraph").SQL = strSQL
'--- then open the report with the graph ---
--
Duane Hookom
Microsoft Access MVP


:

Hi Juane,

I feel sorry to trouble you with this. It is much easier for me look at it
in the design screen.

The crosstab query is based on a query that has two other queries in it.
These two other queries are the ones that contain the criteria.

The following is the SQL from the first of the two queries that contain
criteria. If it is too much trouble, please ignore it. I guess I will try
harder myself to see if I can find out something is wrong.
Thanks.

PARAMETERS [forms]![frmOverallReportCriteria]![cmbPL] Text ( 255 ),
[forms]![frmOverallReportCriteria]![cmbCT] Text ( 255 );
SELECT qryC1000DataMOPChryslerI.Product, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, Val([MOP]) AS NMOP,
qryC1000DataMOPChryslerI.MOP, Val([MIS/Miles]) AS NMIS,
qryC1000DataMOPChryslerI.[YTD/CMP], qryC1000DataMOPChryslerI.[C/1000],
Format([C/1000],"0.00") AS C1000, qryC1000DataMOPChryslerI.ModelYear
FROM qryC1000DataMOPChryslerI
WHERE
(((qryC1000DataMOPChryslerI.PL)=[forms]![frmOverallReportCriteria]![cmbPL])
AND
((qryC1000DataMOPChryslerI.CT)=[forms]![frmOverallReportCriteria]![cmbCT])
AND (Not ([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND (Not
([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL)=[forms]![frmOverallReportCriteria]![cmbPL])
AND ((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND
(([Forms]![frmOverallReportCriteria]![CmbPL])="Totals")) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT]) Is Null) AND
(([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)="TOTALS") AND
(([forms]![frmOverallReportCriteria]![cmbCT])="Totals") AND
(([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null)) OR
(((qryC1000DataMOPChryslerI.PL) Is Null) AND
((qryC1000DataMOPChryslerI.CT)=[forms]![frmOverallReportCriteria]![cmbCT])
AND (([Forms]![frmOverallReportCriteria]![CmbPL]) Is Null))
ORDER BY qryC1000DataMOPChryslerI.Product, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, Val([MOP]), Val([MIS/Miles]),
qryC1000DataMOPChryslerI.ModelYear, qryC1000DataMOPChryslerI.PL,
qryC1000DataMOPChryslerI.CT, qryC1000DataMOPChryslerI.MOP;


Lydia
--
Access/VB Programmer



:

I guess I should have asked to see the SQL of the query containing the
references to the drop-down boxes since that seems to be where the error is
originating.
--
Duane Hookom
Microsoft Access MVP


:

The following is the row source:
TRANSFORM Sum(qryC1000DataMOP.C1000) AS SumOfC1000 SELECT
qryC1000DataMOP.NMIS FROM qryC1000DataMOP GROUP BY qryC1000DataMOP.NMIS ORDER
BY qryC1000DataMOP.NMIS, qryC1000DataMOP.NMOP PIVOT qryC1000DataMOP.NMOP;

Yes. I did set paramers data types in the parameters window.

Thanks.

Lydia



Access/VB Programmer



:

What is the Row Source of the graph? Did you set the data types of the
parameters?

--
Duane Hookom
Microsoft Access MVP


:

Hi,

I have a graph that is based on a crosstab query and have 4 fields that take
input data or parameter values from four drop-down boxes on a form.

When I run the report just by clicking on the report without using the form
that has four drop-down boxes, it works fine no matter what way I entered
those parameter values. However, if I use the form and not select some values
on the form, the graph stop showing. Graphs will show if I select most of
values on the form.


I just wonder what I did wrong.

Thanks.

Lydia
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot get my graph to print 3
Graph not refreshing 2
Duane Hookom's Line graph by code 8
Graph in Report 9
Export Graph to Word or Excel 1
Graph question 5
Crosstab Graph Report not showing Parameters in text box 3
Cannot get graph to work properly 1

Top