Percentile

[Keith S]

I am converting a Excel spreadsheet to a Access report. This report is a
summary page of the data. I have generated a query that collects the data
and then have another query that rolls up the data to totals. On one of the
columns in Excel, it is generating the Percentile. Is there a way to convert
the Excel Percentile function to Access code, either inside the report or on
the query? Thanks for any help.

 

[Olduke]

I am converting a Excel spreadsheet to a Access report. This report is a
summary page of the data. I have generated a query that collects the data
and then have another query that rolls up the data to totals. On one of the
columns in Excel, it is generating the Percentile. Is there a way to convert
the Excel Percentile function to Access code, either inside the report or on
the query? Thanks for any help.

It would probably be easier to just format the text box containing the
report in Access.
Right click the text box, select Properties, click the ALL tab and select
the Format you want on the format line. The ones available are pretty much
the same as in Excel.