473,378 Members | 1,404 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

MS Access - Report Properties

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
1 1761
cyberdwarf
218 Expert 100+
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

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

Similar topics

15
by: Mark C | last post by:
All, I have exhaustingly been looking through the newsgroups in search of a way to systemically output an Access 97 report to a pdf file using the full version of Adobe Acrobat. I want the user...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
0
by: Ann | last post by:
I have an Access 2000 database with 4 memo fields in it named memo1 memo2 memo3 and memo4. Some fields have data in them and some don't. If I create a report and put the 4 fields (with no labels)...
8
by: Jerry | last post by:
I have an off-the-shelf app that uses an Access database as its backend. One of the tables contains a field with an "OLE Object" datatype. I'm writing some reports against this database, and I...
2
by: amith.srinivas | last post by:
Hi all, From a word macro in VBA, I am trying to create a report in access DB. The report is based on a query with a parameter. I am using Set rpt = Application.CreateReport rpt.RecordSource =...
1
by: ellenh | last post by:
I have read postings on the similar subject including the posting from 2003 shown below. This process works fine to display a single page snapshot report in PowerPoint. I need to display...
6
by: DeniseY | last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet....
1
by: JRNewKid | last post by:
I have an Access report. In the source table of data I have a check box, dlyBillCode, which is checked if I want that record to be included in the report. That dlyBillCode itself doesn't appear...
6
by: lyle fairfield | last post by:
ZoomControl is a hidden property of reports. Setting it to zero, makes the report fit the window. The default view of a report created in Access 2007 seems to be Report View rather than the...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.