Store a Calculated Value From a Report?

[Proaccesspro]

How do I do this?? I have a text box that captures the count of a The number of open orders. I need this value to be the STARTING value the next time the report is run....How am I able to store that value until I run the report again??

[MindBender77]

How do I do this?? I have a text box that captures the count of a The number of open orders. I need this value to be the STARTING value the next time the report is run....How am I able to store that value until I run the report again??

You could run an update query to a temp table which then could hold the count of "open orders".. The textbox could then use dlookup to populate from data in the temp table. I know there is an easier way of doing what your asking but, this is the only one I can think of right now.

Bender

[Proaccesspro]

You could run an update query to a temp table which then could hold the count of "open orders".. The textbox could then use dlookup to populate from data in the temp table. I know there is an easier way of doing what your asking but, this is the only one I can think of right now.

Bender

Anyone else?

[NeoPa]

Good manners cost nothing. If you'd responded to my post as you did to MindBender's I'd be looking to avoid you in future. No matter what opinion you had of the response, his attempt to help did not (and never does) deserve such a dismissive response.

Admin.

[NeoPa]

You will find you're more likely to get responses to your questions if they are phrased clearly and carefully.

I'm unsure if it's a count or a "last used" item you want. If it's simply a count then you really shouldn't be saving it anyway, but working it out on the fly in good database fashion.

[Proaccesspro]

You will find you're more likely to get responses to your questions if they are phrased clearly and carefully.

I'm unsure if it's a count or a "last used" item you want. If it's simply a count then you really shouldn't be saving it anyway, but working it out on the fly in good database fashion.

Neopa,

I think your response is harsh....I absolutely meant NO disrepect towards Bender. (Bender, please accept my apology if you thought I was cold). I only wrote what I did so that my posting would remain "active" and hopefully generate further replies and or ideas. I appreciate this service and by no means intended to offend anyone!

[Denburt]

I would like to help however reading over your description I would have to say mindbender is probably sending you down the right road. Your reply to his post did not help you or us in any way, as Neo stated.

If you would like to let us know WHY you asked for another persons response then maybe we can help you further since there are so many variables involved we really need to understand.

1. Do you think MindBenders method won't work? If so please try to explain why it might not work for your app.

2. Do you not understand what he was saying? Don't be afraid to say hey I new at this and I don't understand. Most all of us have been there at some point.

3. Did you just want someone to spew out some code that you could copy paste... I may spit out some code from time to time but unless you come out and say I am a real newby at this I will leave things out of my code to keep things more concise and to the point, the more advanced programmers will generally spot it right off and know what needs to be done to complete it.

Let us know, there are tons of people here that would be more than happy to help. It just helps us help you when you help yourself.

[NeoPa]

Proaccesspro,

I'm happy to accept that you had no intention to cause offence with your post. I would merely ask you to be a little more aware in future. You're a regular poster, and I don't recall any other such posts that have given me cause to pause, so I am happy to consider this resolved.

-NeoPa.