Access: Calculate in report!

[mountnco]

Hi,
I'm currently doing some practice stuff on Access with the MS Northwind sample database! I've been trying to make a calculated control in the invoice report with the expression builder. I've simply added a text box with a label under the OrderID header, then I went to the properties of that text box and used the expression builder in 'control source' to create the following expression:
=[Orders]![RequiredDate]+30

What i'm trying to accomplish with this is a 30 day addition/extention to the reqiured date in the report. But for some reason this doesn't work correctly and when close the report and open it again, it brings up a dialog which says enter parameter value and it simply displays an error in the text box on the report! Any ideas or guidance with this problem would be greatly appreciated! Thanks in advanced!

 

[Remou]

Is the report based on the Orders table or query?

 

[mountnco]

Its based on the table!

 

[Remou]

Silly me. Ditch the Orders! bit.

 

[Remou]

PS If you use the top object in the expression builder, that is the current form or report, the builder will not add the name of the object.

 

[mountnco]

any ideas?

 

[PHV]

=[RequiredDate]+30

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Remou]

I thought I had posted two ideas yes no?

Get rid of Orders!, that is:
=[RequiredDate]+30

 

[mountnco]

Thankyou very much, both, PHV and Remou! Your both Legends!