A
Andrew
Is it possible to use the expression builder to build a sequential numbering
system by lets say setting a default value on a long integer field
(ReportNumber) to1000000 and using the expresion builder (Access 2007) to ad
the Auto number generated to that 10000000? Ex. [Reports].[ID] is auto
number, + [Reports].[IDR] is set at 1000000 so the first report
[Reports].[IDR]=1000001
system by lets say setting a default value on a long integer field
(ReportNumber) to1000000 and using the expresion builder (Access 2007) to ad
the Auto number generated to that 10000000? Ex. [Reports].[ID] is auto
number, + [Reports].[IDR] is set at 1000000 so the first report
[Reports].[IDR]=1000001