Display percentage

[Juliette]

Hi I have two date columns and have worked out the difference between the dates.
Expr1: DateDiff("d",[OrderDueDate],[MLastReceiptDat])

Can someone help how to show the result as a percentage
Thanks
Juliette

 

[Ranman256]

make 2 queries:
Q1, totals the items
Q2, joins Q1 with the Data table and divides the tData.Amt/Q1.Total
(set format to percent)

 

[plog]

Can someone help how to show the result as a percentage

Percent of what? You need 2 numbers for a percentage. What's the other one and which is the numerator?

Unless of course you just want to convert the DateDiff value to a percentage, in which case just add "00%" to it:

Perc: DateDiff("d", [Date1], [Date2]) & "00%"