Link to home
Start Free TrialLog in
Avatar of DavidDF1913
DavidDF1913Flag for United States of America

asked on

Fill a table with values

I want to make an append  query that fills a table with values.  Example:  
table:  chgDateTbl     fields - ProductNo (double), chgDate (date)

The table needs 1,000 records  Only  ProductNo field needs a value to start since this field never changes.  Example:   While ProductNo < 1000 append record and increment ProductNo
ProductNo    chgDate
1
2
3
Thanks  - David
ASKER CERTIFIED SOLUTION
Avatar of carazuul
carazuul

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial