Hi
I am trying to calculate the number of days an item has been outstanding from the received date using todays date.
I would like to use the calculated query for a report which I will create.
I have used the DateDiff function but instead of simply calculating the Outstanding Days for all rows I get a parameter query prompt which I do not want.
I am new to access and hope I have explained what I am trying to do.
This is what I currently have
DateDiff(“d”,[DATE RECEIVED],Now())
Hope I have explained what I need to do.
Thanks
Carl
