By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,311 Members | 1,844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,311 IT Pros & Developers. It's quick & easy.

TOP value

P: n/a
Hi. I have Access 2000.
I have this query that lists record for a given date period (chosen by user
through dialogue boxes - eg. [date from] and [date to] )
When it gives a list of records for the given date period, I would like it
to pick out the first 170 records based on the earliest date (field called
"enquiry date").
I have simply use the properties box for the query and entered the number
170 in the 'Top Values' property field. Its the sorting out of these 170
where i have a problem. It doesn't give me the earliest dates in a given
month for the 170 records. It does not sort in the 'enquiry date'. I have
tried the Order By property field in the query property box by simply
typing [enquiry date]. But no success.
help.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ray
"Manton" <sk**@optusnet.com.au> wrote in message news:<40***********************@news.optusnet.com. au>...
Hi. I have Access 2000.
I have this query that lists record for a given date period (chosen by user
through dialogue boxes - eg. [date from] and [date to] )
When it gives a list of records for the given date period, I would like it
to pick out the first 170 records based on the earliest date (field called
"enquiry date").
I have simply use the properties box for the query and entered the number
170 in the 'Top Values' property field. Its the sorting out of these 170
where i have a problem. It doesn't give me the earliest dates in a given
month for the 170 records. It does not sort in the 'enquiry date'. I have
tried the Order By property field in the query property box by simply
typing [enquiry date]. But no success.
help.


Hello Manton,

Perhaps what you could do is set up two queries. Use the
first one to get your data with the date set to descending.
Then use that query as the source for the second one to get
your 170 records.

Regards,

Ray
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.