Parameter Error

[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!!!

 

[KARL DEWEY]

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.

 

[Stacey Crowhurst]

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

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!!!

 

[KARL DEWEY]

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

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

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!!!

 

[Stacey Crowhurst]

Yay I found it! I forgot the "s" on the sum formula for change orders.
Thanks!!

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

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

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!!!