I am creating a report with LOTS of fields and need to scrunch them all into two pages per report (can't break it up into multiple reports because that would be a big hassle).
I've almost accomplished my task. There are EIGHT date fields in my report and presently they all read like this: xx/xx/xxxx. i.e. 1/1/2003 or 11/21/2004. I desperately need to cut off the first two numerals of each year. I would prefer it to display like this: xx/xx/xx i.e. 1/1/03 or 11/21/04. But stupid Access refuses to let me do this. I go into table design mode, click on the Date/Time data type and in the "format" field at the bottom of the window try to create a custom format but the best I can get is "short date" which is, as I mentioned above, xx/xx/xxxx.
Does anybody know any way that this can be played with so it'll appear as I want it? The 8 characters it would lop off would be inestimably huge in helping me complete my reports.
By the way, in the table itself (it has 1600 records) I made sure that Excel (the program I imported it from) displayed the dates as xx/xx/xx, so EVEN THOUGh the date is imported exactly as I'd like it displayed, STUPID access forces me to adopt a 4-digit year!! argh! please help!
thanks.
I've almost accomplished my task. There are EIGHT date fields in my report and presently they all read like this: xx/xx/xxxx. i.e. 1/1/2003 or 11/21/2004. I desperately need to cut off the first two numerals of each year. I would prefer it to display like this: xx/xx/xx i.e. 1/1/03 or 11/21/04. But stupid Access refuses to let me do this. I go into table design mode, click on the Date/Time data type and in the "format" field at the bottom of the window try to create a custom format but the best I can get is "short date" which is, as I mentioned above, xx/xx/xxxx.
Does anybody know any way that this can be played with so it'll appear as I want it? The 8 characters it would lop off would be inestimably huge in helping me complete my reports.
By the way, in the table itself (it has 1600 records) I made sure that Excel (the program I imported it from) displayed the dates as xx/xx/xx, so EVEN THOUGh the date is imported exactly as I'd like it displayed, STUPID access forces me to adopt a 4-digit year!! argh! please help!
thanks.
Facebook
Twitter