Or similarly in a query use a computed column by putting the following in the 'field' row of a blank column in query design view:Īsset Number: & & & Format(,"0000") Simply use an unbound text box in a form or report with a ControlSource property of: Sooner or later Murphy's Law will come into play and your data will be screwed up. As Marshal says, do not include an Asset Number column in the table! That introduces redundancy and leaves the table wide open to update anomalies.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |