R RevJeff Registered User. Local time Today, 13:23 Joined Sep 18, 2002 Messages 129 Feb 28, 2007 #1 Hi, I have a text field in a table and need to convert it in a query to a number field for sorting purposes, but not have it change in the table. Thanks, Jeff
Hi, I have a text field in a table and need to convert it in a query to a number field for sorting purposes, but not have it change in the table. Thanks, Jeff
RuralGuy AWF VIP Local time Today, 11:23 Joined Jul 2, 2005 Messages 13,825 Feb 28, 2007 #2 NumericField:=CLng([TextField])
R RevJeff Registered User. Local time Today, 13:23 Joined Sep 18, 2002 Messages 129 Feb 28, 2007 #3 Great! Thanks for your help.
RuralGuy AWF VIP Local time Today, 11:23 Joined Jul 2, 2005 Messages 13,825 Feb 28, 2007 #4 Glad I could help.
