Hi Colin,

Thanks for your suggestion, I think it would be very suitable for what I want to achieve.

Sorry for double posting - wasn't sure which DP address to post to.

Michael
Hi Michael,

Find easy way to do this is simply set search conditions using a formula (option 3) on that report

Assume your index field is P1F2

P1F2 = 017 OR P1F2 = 177 OR P1F2 = 278 OR P1F2 = 279 OR P1F2 = 450 OR etc etc

Once saved each time you want to run report using new numbers then Shft F7 - 4 - Use current search (Y/N) Select No - Then 3 Specify Formulae - Previous list is there - overwrite new values and save and include those conditions and run report. Next time repeat changing to new numbers. Trick is don't delete the search conditions each time and they are there to overwrite next time.

Suspect achievable with complex Report variables but still required entering each number so Specify formulae (option 3) achieves same results. I have long formulae that if only a few numbers needed I copy and save numbers not needed and put/paste back after report is run so not having to use F4 to select field each time. (hope you follow)

Cheers

Colin Roberts


On 07-Dec-16 12:04, Michael Iannantuoni wrote:
Although I use DataPerfect still, it is mainly with databases I created

a while ago so when I comes to write something new, I find I have
forgotten how to do fairly simple things!

I have a database in which each record has an index number in the format
GZZ9.

I wish to run a report that prompts the user to enter a list of index
numbers to be extracted  and list only those but I can't seem to get
this to work.

Any help much appreciated.

Michael

_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf

_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf

Reply via email to