Adding Sequential Values to Make-Table Query

[obrien.robj]

Hi new friends,

Using a make-table query to allow users to specify a particular date range (from a wide range of dates) to quantify by day the occurrence of a specific event. I then need to group these dates according to the unique lead times of specific items so that I can aggregate them by replenishment cycle (i.e. 10 day lead time the first 10 days is one replenishment cycl). I am running into issues with assigning these dynamic date ranges unique item numbers so that I can look at them by replenishment cycle. I somehow need to add a sequential number to each observation in my user selected date range so that I can divide that observation by the lead time, round up the value, and aggregate by replenishment cycle.

How, within a make-table query, can I assign a unique value by row that starts at one and ends at the last record?



I have two tables:

Selected Item Number, which contains fields: Part Number & Lead Time

Usage_by_Date, which contains fields: Date & Usage History

If I can somehow autonumber each date then I will be golden, as I can insert a calculation to round up autonumber/lead time.

Apppreciate any help.

~ Rob

[NoellaG]

Hi,

can't you just first create the table, and then add an autonumber field (manually or by code)?

NG

[obrien.robj]

Hi Noella,

Thanks for your response. That would work fine, but I don't know how (in an automated fashion) to add an autonumber to table that I create. Can you walk me through that? I am aware of how to do it manually, but this will be used with great frequency and I can't have a manual step each time.