Enter parameter value

[Wessel Heinen]

Hello,

I am trying to make an order system that devides the 6% and 19% VAT totals on the invoice.

Basically I have a query that gets all the information the invoice form. Now i made to filter query's. One that filters the 19% and one that filters the 6% products. in the query builder I added a calculation that says ''product total * 0,06 '' (or 0,19 for the 19%)

Now I want the result of that sum to show in the report.
When I add a controle source in the report for a textbox. I select the row that gives the results of the sums.

Now i run the report and it says enter paramete value! I dont understand why.

Can someone help me? thanks

[Adam Tippelt]

Enter parameter value usually means that something is trying to reference a control that is either not open, or has been deleted/renamed. It can't find the value itself, so it's asking you to give it the value.

If you've build a query based on controls on a form, and you're now trying to use the same query for a report, it's probably looking for a value from a control on the original form, but cannot find it because the form is not open.

Adam.

[Narender Sagar]

You added calculation field 'product total * 0,06 '' (or 0,19 for the 19%)'
Do you have 'product total' field in your table. I presume your query is unable to understand this field.
If you have this field in table, then type the calculated field as exactly as follows:
NewName: ([product total]*0.06)

[NeoPa]

When you get the "Enter Parameter Value" prompt that means that there is something in your SQL that Jet (Access SQL) doesn't recognise as available.

This can be for various reasons, some of which I'll list :

1. The query was designed to prompt the user for a value.
2. The SQL contains a reference to an object (Form Control, Field, etc) is misspelled (so is never available).
3. The SQL contains a reference to an object that is currently not available (generally due to its being on a form that is not currently open).

If we're to help you find this anomaly then we'll need to see your SQL at least.