D dsthome Registered User. Local time Today, 15:13 Joined Jan 21, 2011 Messages 24 Feb 3, 2011 #1 Hi I have a primary key autonumber set up which increases by 1 each time. I was wondering if it is possible only to display the last 3 digits when using tihs number on forms / reports etc. Dave
Hi I have a primary key autonumber set up which increases by 1 each time. I was wondering if it is possible only to display the last 3 digits when using tihs number on forms / reports etc. Dave
G Galaxiom Super Moderator Staff member Local time Tomorrow, 02:13 Joined Jan 20, 2009 Messages 12,832 Feb 3, 2011 #2 In the field cell of the query designer: NewName: Right([fieldname],3)
