By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,619 Members | 1,712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,619 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

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

Expert Mod 15k+
P: 31,494
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

Expert Mod 5K+
P: 5,397
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.