A Anauz Registered User. Local time Today, 22:22 Joined Nov 14, 2000 Messages 81 Feb 9, 2001 #1 Hi I have a form where the user enters a number x), I want to use this number to return the first X records in a query. Is this possible....if so can anyone help? Thanx in advance
Hi I have a form where the user enters a number x), I want to use this number to return the first X records in a query. Is this possible....if so can anyone help? Thanx in advance
N ntp Registered User. Local time Today, 22:22 Joined Jan 7, 2001 Messages 74 Feb 10, 2001 #2 Modify your query like this: original query: SELECT field1, field2 FROM qrySample New query: SELECT TOP X field1, field2 FROM qrySample ORDER BY field1 The new query returns the first X records returned when the queryis sorted by field1. ntp
Modify your query like this: original query: SELECT field1, field2 FROM qrySample New query: SELECT TOP X field1, field2 FROM qrySample ORDER BY field1 The new query returns the first X records returned when the queryis sorted by field1. ntp
A Anauz Registered User. Local time Today, 22:22 Joined Nov 14, 2000 Messages 81 Feb 11, 2001 #3 Thats great, thanks very much. Is there a way i can pass the parameter X to the query so it returns X records?
Thats great, thanks very much. Is there a way i can pass the parameter X to the query so it returns X records?
