asked on
Maximum (up to 2) Records
Hi there,
Can you please help with this nagging issue?
There is date in a table and the field I am using is a date field. I'd like to extract the TWO most recent entries in the field - I know you can use min and max but can you select the number of min/max fields?
Thanks very much in advance,
CS
Can you please help with this nagging issue?
There is date in a table and the field I am using is a date field. I'd like to extract the TWO most recent entries in the field - I know you can use min and max but can you select the number of min/max fields?
Thanks very much in advance,
CS
Crystal Reports
Last Comment
James0628
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Look at
REPORT --> GROUP SORT EXPERT
mlmcc
REPORT --> GROUP SORT EXPERT
mlmcc
ASKER
It's dimmed out - no ability to sort.
cs
cs
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Works perfectly!
Thank you - cs
Thank you - cs
You're welcome. Glad I could help.
James
James
Can you please tell me a little more regarding this? I have it currently group by the date (in the command insert group, it allows you to sort according to a specified order etc. but I don't see anything that would directly refer to what you mention.
Thank you - cs