Parameter Error

  • Thread starter Thread starter Stacey Crowhurst
  • Start date Start date
S

Stacey Crowhurst

Hi. I have a report based on a query. The value for change orders askes me
to enter the parameter value for change orders when I view the report. The
query works fine by itself and does not give the same error. I'm at my wits
end to figure out why the report is doing it. Here is the query SQL:

SELECT [Q- Contract_Detail 02].[CCP No], [Q- Contract_Detail 02].[PO No],
[Q- Contract_Detail 02].Contract, [Q- Contract_Detail 02].[Vendor Name], [Q-
Contract_Detail 02].[Phase Code], [Q- Contract_Detail 02].[Phase
Description], [Q- Contract_Detail 02].[Cost Code], [Q- Contract_Detail
02].[Cost Code Desc], [Q- Contract_Detail 02].[Contract Fee], [Q-
Contract_Detail 02].[Paid to Date], Nz([Line Amount],0) AS [Change Orders]
FROM [Q- Contract_Detail 02] LEFT JOIN [Q- Contract_Change Orders] ON ([Q-
Contract_Detail 02].[Cost Code] = [Q- Contract_Change Orders].[Cost Code])
AND ([Q- Contract_Detail 02].Contract = [Q- Contract_Change Orders].Contract);

Any help is greatly appreciated!!!
 
Open your report in design view and see where you may have entered [Change
Orders] with a different spelling or punctuation. If you can not find it
that way the use the Documentor to analyze the report for it.
 
Karl:

I looked at the report and the only things I saw with [Change Orders] is the
label box called "Change Orders_Label" and the text box called "Change
Orders". How would I have the Documentor analyze it?

Thanks,
Stacey

KARL DEWEY said:
Open your report in design view and see where you may have entered [Change
Orders] with a different spelling or punctuation. If you can not find it
that way the use the Documentor to analyze the report for it.

--
KARL DEWEY
Build a little - Test a little


Stacey Crowhurst said:
Hi. I have a report based on a query. The value for change orders askes me
to enter the parameter value for change orders when I view the report. The
query works fine by itself and does not give the same error. I'm at my wits
end to figure out why the report is doing it. Here is the query SQL:

SELECT [Q- Contract_Detail 02].[CCP No], [Q- Contract_Detail 02].[PO No],
[Q- Contract_Detail 02].Contract, [Q- Contract_Detail 02].[Vendor Name], [Q-
Contract_Detail 02].[Phase Code], [Q- Contract_Detail 02].[Phase
Description], [Q- Contract_Detail 02].[Cost Code], [Q- Contract_Detail
02].[Cost Code Desc], [Q- Contract_Detail 02].[Contract Fee], [Q-
Contract_Detail 02].[Paid to Date], Nz([Line Amount],0) AS [Change Orders]
FROM [Q- Contract_Detail 02] LEFT JOIN [Q- Contract_Change Orders] ON ([Q-
Contract_Detail 02].[Cost Code] = [Q- Contract_Change Orders].[Cost Code])
AND ([Q- Contract_Detail 02].Contract = [Q- Contract_Change Orders].Contract);

Any help is greatly appreciated!!!
Click to expand...
Click to expand...
 
Click on TOOLS - Analyze - Documentor. Click on Reports, select your report,
click on Opthions, select Names and Properties.
Save to Word. Open the .RTF document and search for the Change Orders.
--
KARL DEWEY
Build a little - Test a little


Stacey Crowhurst said:
Karl:

I looked at the report and the only things I saw with [Change Orders] is the
label box called "Change Orders_Label" and the text box called "Change
Orders". How would I have the Documentor analyze it?

Thanks,
Stacey

KARL DEWEY said:
Open your report in design view and see where you may have entered [Change
Orders] with a different spelling or punctuation. If you can not find it
that way the use the Documentor to analyze the report for it.

--
KARL DEWEY
Build a little - Test a little


Stacey Crowhurst said:
Hi. I have a report based on a query. The value for change orders askes me
to enter the parameter value for change orders when I view the report. The
query works fine by itself and does not give the same error. I'm at my wits
end to figure out why the report is doing it. Here is the query SQL:

SELECT [Q- Contract_Detail 02].[CCP No], [Q- Contract_Detail 02].[PO No],
[Q- Contract_Detail 02].Contract, [Q- Contract_Detail 02].[Vendor Name], [Q-
Contract_Detail 02].[Phase Code], [Q- Contract_Detail 02].[Phase
Description], [Q- Contract_Detail 02].[Cost Code], [Q- Contract_Detail
02].[Cost Code Desc], [Q- Contract_Detail 02].[Contract Fee], [Q-
Contract_Detail 02].[Paid to Date], Nz([Line Amount],0) AS [Change Orders]
FROM [Q- Contract_Detail 02] LEFT JOIN [Q- Contract_Change Orders] ON ([Q-
Contract_Detail 02].[Cost Code] = [Q- Contract_Change Orders].[Cost Code])
AND ([Q- Contract_Detail 02].Contract = [Q- Contract_Change Orders].Contract);

Any help is greatly appreciated!!!
Click to expand...
Click to expand...
Click to expand...
 
Yay I found it! I forgot the "s" on the sum formula for change orders.
Thanks!!

KARL DEWEY said:
Click on TOOLS - Analyze - Documentor. Click on Reports, select your report,
click on Opthions, select Names and Properties.
Save to Word. Open the .RTF document and search for the Change Orders.
--
KARL DEWEY
Build a little - Test a little


Stacey Crowhurst said:
Karl:

I looked at the report and the only things I saw with [Change Orders] is the
label box called "Change Orders_Label" and the text box called "Change
Orders". How would I have the Documentor analyze it?

Thanks,
Stacey

KARL DEWEY said:
Open your report in design view and see where you may have entered [Change
Orders] with a different spelling or punctuation. If you can not find it
that way the use the Documentor to analyze the report for it.

--
KARL DEWEY
Build a little - Test a little


:

Hi. I have a report based on a query. The value for change orders askes me
to enter the parameter value for change orders when I view the report. The
query works fine by itself and does not give the same error. I'm at my wits
end to figure out why the report is doing it. Here is the query SQL:

SELECT [Q- Contract_Detail 02].[CCP No], [Q- Contract_Detail 02].[PO No],
[Q- Contract_Detail 02].Contract, [Q- Contract_Detail 02].[Vendor Name], [Q-
Contract_Detail 02].[Phase Code], [Q- Contract_Detail 02].[Phase
Description], [Q- Contract_Detail 02].[Cost Code], [Q- Contract_Detail
02].[Cost Code Desc], [Q- Contract_Detail 02].[Contract Fee], [Q-
Contract_Detail 02].[Paid to Date], Nz([Line Amount],0) AS [Change Orders]
FROM [Q- Contract_Detail 02] LEFT JOIN [Q- Contract_Change Orders] ON ([Q-
Contract_Detail 02].[Cost Code] = [Q- Contract_Change Orders].[Cost Code])
AND ([Q- Contract_Detail 02].Contract = [Q- Contract_Change Orders].Contract);

Any help is greatly appreciated!!!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top