Help generating line item number in order table

[orange]

So you could write your data to a table and then export the Table. You could probably include the relevant pieces in the Export routine???

[acenumber5]

So you could write your data to a table and then export the Table. You could probably include the relevant pieces in the Export routine???

Exactly... At least that's the plan... Although, I keep running into things that excel can do, but I can't figure out in Access... ie The date field. The distributor wants the date in MMDDYYYY format which excel does easily, but Access doesn't..

[orange]

ReqdDate = Format(YourDateField,"MMDDYYYY")

[acenumber5]

Once again Thank you!