By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,430 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Access 2010 report - Record color different if updated in last 30 days

P: 1
My customer wants to see the records updated in the last 30 days to change color on his report. There is no update date field in report. Can this be done?
Nov 8 '12 #1
Share this Question
Share on Google+
3 Replies


zmbd
Expert Mod 5K+
P: 5,287
This is possible
Which version of Access are you using?
Conditional Formatting of Reports MS Access 2010
Nov 8 '12 #2

NeoPa
Expert Mod 15k+
P: 31,186
It can be done if there is such a field in the table. You can add fields to a report without them necessarily showing.

If the data doesn't exist then no. You cannot check data if it doesn't exist.
Nov 9 '12 #3

zmbd
Expert Mod 5K+
P: 5,287
NeoPa has a very valid point and one I am remiss in not mentioning.

With that said however, without an understanding of your DB it may be a bit premature to discount the possibility of the highlighted records just because one table is missing an "update*" field. You may have an audit table or something that is linked, altered, or created whenever a record is updated that has such a time stamp... you will have to take a very careful look at the skeleton of your data to see what is available to test against.
Nov 9 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.