How can I force a report to display a two-digit year?
My computer was recently upgraded, and I went from Access 2000 to Access 2003. My reports now show a four-digit year.
I have the report columns squeezed just so to fit on the page. The four-digit year is throwing me off.
I tried the help file, which tells me how to force it to a four-digit year, but not force it back to two-digits. I also tried the “format” line in the design view of the table - the “short year” is four-digits - there is no option for two.
Right click the heading of the column with the dates in it to highlight the entire column and display the popup menu. Select “Format cells” from the popup menu. On the “Number” tab select “Date” from the list of categories, then select the date format of your choice from the list.
I have a report that creates a letter to donors. It says, “I want to thank you for your generous donation of xx,” where XX is an If/then statement. If their donation was in-kind, it’ll return the comment field in the donation table: “I want to thank you for your generous donation of a washing machine.” If the donation was cash, it returns the donation_amount field in the same table: “I want to thank you for your generous donation of 40.”
Obviously that last line is insufficient, so I surround it with “$” on the left and “.00” on the right. But very occasionally we receive a donation of an odd amount, like $123.35. In such cases, the report reads “I want to thank you for your generous donation of $123.35.00” unless I go in and manually change the report for this donation.
How can I change the formatting of a number within an if/then statement?
The current coding is a text box with the following line in it:
You should be able to format the [Amount Paid] field as currency. This will put the correct monetary symbol in front of the number, and use two decimal places.