I need to add a field for Invoice number. I want the field to be the year the record is submitted followed by a dash and then the ID of the record (AutoNumber field). Can I put such a field right in my table or would it have to be part of a query? How would I go about formatting the field?
Creating field from other fields
- Thread starter betheball
- Start date
dcx693
Registered User.
- Local time
- Yesterday, 20:46
- Joined
- Apr 30, 2003
- Messages
- 3,265
Why even create this field in your table? Why not just calculate it when you need to use it? I would just calculate it in a query. Formatting the field would be easy, typically done using the all-purpose Format() function, something like:
Format(Year([Date_Submitted],"yyyy")&"-"&Format([Autonum_Field],"0000")
Format(Year([Date_Submitted],"yyyy")&"-"&Format([Autonum_Field],"0000")