473,385 Members | 1,409 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,385 software developers and data experts.

Access Report - selecting detail records to print

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 anywhere on the report.
What's the best way to do this? Looking at my book it appears I could either do an IIF or use a filter in the properties for the report. I couldn't get either one to work.
I couldn't figure out the IIF because the example in the book uses a field that appears on the report, which mine doesn't. I tried the filter by going into the properties for the report and then on Filter I typed in dlyBillCode= true (is that the right way to test a check box!!) and then setting Filter on to Yes. but it just didn't have any effect on the report.
Any help would be appreciated, thank you.
Apr 19 '07 #1
1 1836
ADezii
8,834 Expert 8TB
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 anywhere on the report.
What's the best way to do this? Looking at my book it appears I could either do an IIF or use a filter in the properties for the report. I couldn't get either one to work.
I couldn't figure out the IIF because the example in the book uses a field that appears on the report, which mine doesn't. I tried the filter by going into the properties for the report and then on Filter I typed in dlyBillCode= true (is that the right way to test a check box!!) and then setting Filter on to Yes. but it just didn't have any effect on the report.
Any help would be appreciated, thank you.
Change the underlying RecordSource of the Report from a Table to a Query. Include the [dlyBillCode] Field in the Query, and set the Criteria in this Field to True.
Apr 19 '07 #2

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

Similar topics

3
by: Ranman | last post by:
Hi all, I have a simple problem that hopefully has a simple solution, but I have yet to figure it out. In a patient database, I have a physician test order form that populates a report that is...
4
by: Dale Ring | last post by:
Access 2000 I am trying to print a report that only some of the records have pictures. When the report prints, I do not want a blank image control showing on the report. This project is a test...
9
by: Colin McGuire | last post by:
Hi, I have an report in Microsoft Access and it displays everything in the table. One column called "DECISION" in the table has either 1,2, or 3 in it. On my report it displays 1, 2, or 3. I want...
1
by: David Horowitz | last post by:
Hi folks. I need to create a report that has a Group Header that pulls certain data from the Detail section. It's something like this: +--Report---------------------------------------- |...
7
by: itm | last post by:
I have a mail out to send to a group of owners with multiple accounts. I want to limit the number of accounts that print on the first page to 20. I want remaining accounts to print on a second...
1
by: sonicfun2006 | last post by:
I have SQL Server Database and MS Access 2003 is connected with ODBC. I have very large amount of records in various tables. The database is very dynamic as it changes every minute. I’m trying to...
10
by: sara | last post by:
Hi - Is it possible to hide the detail section of a report at run time? I have a report that prints all details, with summary lines. The user would like the report ALSO with just summary lines....
0
by: retrorocket | last post by:
I've searched and searched, I could really use some suggestions. I have a Crystal Report in report designer that contains a Report Header, a Page Header, and a Detail section. The first page should...
14
ollyb303
by: ollyb303 | last post by:
Hi, I am trying to create a dynamic crosstab report which will display number of calls handled (I work for a call centre) per day grouped by supervisor. I have one crosstab query (Query1) which...
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: 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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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.