Automatically transfering a value from one text box to another

[ckpoll2]

Hello,

I'm creating a form that will always show information for the last 7 days by using date() and date()-1 and so forth. What I need to do is have a value that has been calculated in a text box (aka not stored in any table, only calculated by numbers from a table) to automatically populate into a different text box the next day so that all the numbers will shift with the passing of a day. Is this possible to do?

Thanks,

Charlie

[comteck]

Do you want the new value to be stored in a table, or just appear in an unbound textbox?

comteck

[ckpoll2]

Do you want the new value to be stored in a table, or just appear in an unbound textbox?

comteck

I'd be happy with either. All that I need is for it to appear in an unbound textbox, which seems to me like it would be easier. If I'm wrong, though, and it's easier to store it, that's fine, too. Any suggestions?

[ckpoll2]

Does anyone have any ideas as to how I can solve my problem?

[PEB]

Hi,

It will be possible if you give us an exemple! I can give you now a lot of ideas but it's better to know what do you like to do with your data!

For the moment we know that you have table with information introduced by days

And you want to do some calculations on this data...

And this calculation have to be shown into unbound field in the form!

But it have to concern the next day??? The next day from today from yesterday! I'm afraid but for me it isn't clear!

Please give us an exemple!

[ckpoll2]

Sorry for the confusion.

What I'm doing is creating a form that will keep track of e-mails processed and received by our customer service department. The form will show data for the last 7 days with the days with the days automatically updating to reflect the current day by using date(), date()-1 and so on. I have text boxes for beginning balance, e-mails received, e-mails processed, and ending balance with the ending balance for one day carrying forward to the beginning balance for the next.

The problem is that the beginning balance for the 7th day has no ending balance box to populate a number into. What I need to do, therefore, is have the beginning balance box for the 6th day, a number that is not stored in a table but merely calculated using numbers that are stored, carry to the beginning balance for the seventh day when the days change so that the numbers will be accurate. I have been able to have everything else carry forward, but I can't seem to get the beginning balance to move forward.

I hope this is enough information. Please let me know if you have any other questions.

Thanks for all your help,

Charlie

[PEB]

Thank you now it is easier to create a formula that helps to obtain the start balance

You can use this expression: =nz(DCount("ID_ outgoing_mail", "Outgoing_mails ","Mail_date<Da te()-7"))
-nz(DCount("ID_i ncoming_mail"," Incoming_mails" ,"Mail_date<Dat e()-7"))

if every mail is separate line!

The arguments of Dcount dunction are
Dcount(FieldNam e, Table name,Where condition)
ID_incoming_mai l is a field in your table
Incoming_mails is your table

Mail_date<Date( )-7 is your where condition!

Mail_date is the sended date of the mail!

Have a nice day!

[PEB]

If this don't gives the needed results, don't hesitate! :)