I need to loop through a recordset and add records with sequential letters... specifically A - I.
Below is the code I have so far, which obviously is not working.
Dim j As Text, i As Text
Dim rs As DAO.Recordset
i = "I"
Set rs = CurrentDb.OpenRecordset("Publication_Ad")
For j = "A" To i
!Ad_ID = "36.02"
!Position = j
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…