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

MS Access - Report Properties

P: 1
I'm climbing back into Access after about 8 years. The rust is painful..

Question: In Reports, in a data control property box, i'm trying to go beyond source\field. I want to set a specific field value.

So for example, Table: Employees, Field: Status. I want to go a step further and say only run the value "Full-Time"

It seemed like it might be straight forward as I opened the expression builder but i'm not doing something right in building the expression because it won't take it. Any ideas?

Thanks,
T.
Jun 5 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 218
Tony

Do you mean you want to filter to records containing only the value "Full-time"?

If so you will need to set the report filter property. This can be done dynamically incode
Expand|Select|Wrap|Line Numbers
  1. Me.FilterOn=True
  2. Me.Filter = "Status = 'Full-Time'"
Obviously, you could replace "Full-Time" with a variable name to give more flexibility.

HTH
Steve
Jun 6 '07 #2

Post your reply

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