prompt user to type number records

[ashley1]

Hello everyone

need sum help stuck on a simple query
im trying to create a basic query which prompts user to type number records they would like to view, so say we have 5000 records, from the 5000 the user only wants to see 100 or 50 or 20
how can i go about doing this
thanks

 

[Ukraine82]

You can try using the top value on your toolbar (between totals and properties). Another way of doing is probably using a criteria function. If you have a date field you can try using the between function, greater than, or equal too.

hth,
Michael

 

[ashley1]

thanks for reply
but i dont have a date field that i can use
i have tried using the top value but i would like the user to type in the number of records like a parameter e.g. show me 100 records then maybe next time the user only wants to see 25 then maybe different next time
any more ideas?

 

[Ukraine82]

Ashley,

Did you try searching the forum for Select Top Value?

Your best option would be hope somebody in here has an answer for you.

sorry,
Michael

 

[ashley1]

yeah ive had a look and not really found what i need
thanks anyway

i have another question based around this query

if i use select top 50 then if i want to update the top 50 with say todays date in the date field is there a way i can do that?
As everytime im trying to change the select query to update the top 50 disappears!

 

[Ukraine82]

Did you trying using this formula in criteria date field

Date()

hth,
Michael

 

[ashley1]

Sorry for late reply

I have but it puts date in all the records, when i only want it to put date in the top 50 i select!!