Skip,
The copy to on the LNG never changes, LNG is an overly complicated calc, the copy to on the last part which goes to the Review is what will change and the copied cells are from that same row. I'll try your code and let you know how it worked, thanks alot!!!!
Tom
I am trying to create a macro in Excel. I need it to copy certain data from a specific row. The row would be based on the last cell with data in a specific column. After I copy each peice of data it gets pasted into another worksheet, then they all get put through a calculation, and I want the...
In queries you turn on the total row,[right click ,in design view and click on the sigma symbol] that should make it easier for you to figure out.
On reports
Open the report in Design view.Add a calculated text box to one or more of the following sections:How?To calculate a total or average for...
Xianman,
Not sure if this is what you want, you can create a label in design view and place next to the results, ex Jan. [results]123 or when you create your text box, name it as such. Is this what you need?
Try this one,
Create a SQL statement for a form Open the form in Design view or.Right-click the form selector or the report selector to open Build Event, then Expression Builder. You should be able to do it from there.
This might help or you can do it all in a query first
Modify SQL statement for a form or report
Open the form in Design view or the report in Design view.
Double-click the form selector or the report selector to open the property sheet.
Click the Build button next to the RecordSource property...
I have set up a user's guide to be run with acrobat reader 6.0 on our system, the problem is now the users have access to the server's other files through acrobat. How can I stop this.
I've had that problem with my Dell and Fuji Finepix, everything else I plug in works fine. I find turning the camera off & on fixes it, for that use anyway.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.