Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access: Calculate in report!

Status
Not open for further replies.

mountnco

IS-IT--Management
Jan 31, 2006
10
AU
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!

 
Is the report based on the Orders table or query?
 
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.
 
=[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
 
I thought I had posted two ideas yes no?

Get rid of Orders!, that is:
=[RequiredDate]+30
 
Thankyou very much, both, PHV and Remou! Your both Legends!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top