is Grouping available in forms like in report

[trident]

I have created a report with grouping like this sample

LPO Amount Invoice Amount
1234 95,000.00 16-001 15,000.00
16-002 35,000.00
5679 100,500.00 16-003 500.00
16-004 50,000.00

Can this be done in a form view?

Thank you .

Trident

[CJ_London]

forms do not have the grouping sections like reports so the short answer is no.

However depending on your data you can get a similar effect using conditional formatting.

Your source query needs to bring through a calculated field to indicate whether this is the first record in the LPO set

Something like

SELECT *, Invoice=(SELECT min(invoice) FROM myTable as T WHERE LPO=myTable.LPO) AS isFirst
FROM myTable
ORDER BY LPO, Invoice

then set conditional formatting to make the foreground/background of the LPO control the same as the detail when isFirst is false

[trident]

In report, can you group up to 10 columns?

[CJ_London]

see for yourself

https://support.office.com/en-us/art...7-3e1fba6d6c96