Single data to be entered in multiple rows instantly!

Joined
Jun 30, 2011
Messages
1
Reaction score
0
Dear All,

I have a table containing 2 columns in MS Access. 1st column contains primary key (Date) and the second one needs user input in number format. (Note that this table is interrelated with other tables.)

I require the user to select a range of dates (preferably as start and end date) and then input the number. This number would be stored in the second column against the selected dates.

Reason:
The user input is a number that remains same for the whole month but may or may not change for the next month. Additionally, this number would be used in other calculation in the related tables.

Thanks!
 
Back
Top