11/27/2023 0 Comments Ms access concatenate![]() 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 |