I am using an Access database with the following fields:


1) Month and Year [textbox]
2) Funded Amount [textbox]; ([this is displayed in currency])
3) Reimbursement [checkbox]
4) Grant [checkbox]

When I create a report or export to excel, I have the following columns of data:
1) Month and Year
2) Funded Amount (currency)
3) Reimbursement (Yes or No)
4) Grant (Yes or No)

I want to create the report or export this information to Excel or Crystal Report with a different format showing the 'Funded Amount' currency information in the corresponding column under 'Reimbursement' or 'Grant' column instead of the Yes or No.

Is there a way to do this? Thanks for your help.