W
website designer via AccessMonster.com
Data entry form:
I need to display two text boxes:
1. the average value of a field1 from existing data
2. a bound text box that is waiting for data entry for field1.
Further, the value of the field needs to be restricted to two fields:
1. the store-number selected from the combo box
2. the accounting-period from another combo-box
the average query might look like:
select avg field1 where store-number = combo-box and accounting-period between combo-box and combo-box - 365
I need to display two text boxes:
1. the average value of a field1 from existing data
2. a bound text box that is waiting for data entry for field1.
Further, the value of the field needs to be restricted to two fields:
1. the store-number selected from the combo box
2. the accounting-period from another combo-box
the average query might look like:
select avg field1 where store-number = combo-box and accounting-period between combo-box and combo-box - 365