Entering forumla in text box on form

[leewisener]

I have a form linked to a query and want to put a text box on to calculate a total of payments received between two dates.

The fields in the query are:

date
amount

So I would want to do something like:

sum [amount] were date is between x and y

Anyone help?

Thanks

Lee

 

[DPlank]

Look in the help for the SUMIF function. Then return the value calc'd by the formula to the textbox.

Or calculate it in the form code and call it after the data refresh.

Cheers,
Dave

Probably the only Test Analyst on Tek-Tips

animadverto vos in Abyssus!

Take a look at Forum1393 & sign up if you'd like