T tripico Registered User. Local time Today, 14:03 Joined Oct 14, 2005 Messages 23 May 7, 2009 #1 Is there a way to only show the last 30 records of a query? I was looking into throwing the data into a chart and only want to show the last/top 30 records.
Is there a way to only show the last 30 records of a query? I was looking into throwing the data into a chart and only want to show the last/top 30 records.
rainman89 I cant find the any key.. Local time Today, 17:03 Joined Feb 12, 2007 Messages 3,013 May 7, 2009 #2 sure there is a [SIZE=-1]SELECT TOP # option you can use[/SIZE] just put the 30 in for the #
T tripico Registered User. Local time Today, 14:03 Joined Oct 14, 2005 Messages 23 May 7, 2009 #3 Ok.. just found out it was in the Query Properties. Thanks
