Hi
I have a table in which lies a list of tasks. i need to produce a layout that will list found records, and show a "quantity", a number of times it occurs in the found set. I additionally only need the item to be shown once, and not for each occurrence of it.
Please can you advise. If I haven't worded it very well I apologise, and please ask any questions that would help.
Thanks,
Mike
This would depend on how you have your tables and relationships set up. If there is an "item Summary" table where you have a single record for each entry you could relate it to the table of records where it appears more than once.
then in the item summary table use count() to or a summary field to give the total times that item is listed
If there isnt a relationship and no other way to make it work based on the data model and relationships an executeSQL() may be your easiest, but not best method. You can add this calculation field to any layout based on any table
An example calculation
ExecuteSQL(" SELECT DISTINCT ItemField, COUNT(ItemField) FROM TableName" ; " - " ; "" ; "")